Forums / Developer / Miraculous administration interface capabilities

Miraculous administration interface capabilities

Previous topic

Developer

Next topic

Author	Message
Piotrek Karaś	Thursday 20 December 2007 3:05:11 am We've observed very curious eZ Publish (4.0.0) behavior, and I'm not actually sure if this is due to implementation mistake or maybe something wrong with the application itself, or maybe that's standard. Like with each installation, we try to fine tune the caching mechanism so that - amongst other - it works with smallest possible amount of database queries per view. <b>Now the thing:</b> when we completely remove cache files, and then run any public siteaccess, the lowest mysql_queries count we are able to get down to is around <b>12-15</b>, no matter what we do. Now, we log in to the administration panel just for a view, content tab. <b>From that moment on mysql_queries count for our public siteaccesses drops down to around 3 !!!</b> Can anyone explain what's going on? Thanks, Piotrek -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu
Piotrek Karaś	Thursday 07 February 2008 2:47:06 am <b>Another thing.</b> When we clear all the cache (with script or over file system), and then request the administration interface siteaccess before a public one, then the public one will have many of its translations missing (or available in English). This happens with a extension-based design, if that could be a hint. If it could be our mistake - what could that be? Greets, Piotrek -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu

Author

Message

Piotrek Karaś

Thursday 20 December 2007 3:05:11 am

We've observed very curious eZ Publish (4.0.0) behavior, and I'm not actually sure if this is due to implementation mistake or maybe something wrong with the application itself, or maybe that's standard.

Like with each installation, we try to fine tune the caching mechanism so that - amongst other - it works with smallest possible amount of database queries per view. Now the thing: when we completely remove cache files, and then run any public siteaccess, the lowest mysql_queries count we are able to get down to is around 12-15, no matter what we do. Now, we log in to the administration panel just for a view, content tab. From that moment on mysql_queries count for our public siteaccesses drops down to around 3 !!!

Can anyone explain what's going on?

Thanks,
Piotrek

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Piotrek Karaś

Thursday 07 February 2008 2:47:06 am

Another thing.

When we clear all the cache (with script or over file system), and then request the administration interface siteaccess before a public one, then the public one will have many of its translations missing (or available in English).

This happens with a extension-based design, if that could be a hint.

If it could be our mistake - what could that be?

Greets,
Piotrek

eZ debug

Timing:

Jan 20 2025 20:16:42

Script start

Timing:

Jan 20 2025 20:16:42

Module start 'content'

Timing:

Jan 20 2025 20:16:42

Module end 'content'

Timing:

Jan 20 2025 20:16:42

Script end

Main resources:

Total runtime

0.0177 sec

Peak memory usage

2,048.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	587.8438	180.8125
Module start 'content'	0.0055	0.0065	768.6563	93.9297
Module end 'content'	0.0120	0.0056	862.5859	70.7031
Script end	0.0177		933.2891

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0055

587.8438

180.8125

Module start 'content'

0.0055

0.0065

768.6563

93.9297

Module end 'content'

0.0120

0.0056

862.5859

70.7031

Script end

0.0177

933.2891

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	12.1754	12	0.0002
Check MTime	0.0010	5.5763	12	0.0001
Mysql Total
Database connection	0.0006	3.6117	1	0.0006
Mysqli_queries	0.0024	13.7726	4	0.0006
Looping result	0.0000	0.0727	2	0.0000
Template Total	0.0052	29.4	1	0.0052
Template load	0.0010	5.3624	1	0.0010
Template processing	0.0043	24.0278	1	0.0043
Override
Cache load	0.0007	3.7140	1	0.0007
General
dbfile	0.0013	7.5477	10	0.0001
String conversion	0.0000	0.0390	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0022

12.1754

0.0002

Check MTime

0.0010

5.5763

0.0001

Mysql Total

Database connection

0.0006

3.6117

0.0006

Mysqli_queries

0.0024

13.7726

0.0006

Looping result

0.0000

0.0727

0.0000

Template Total

0.0052

29.4

0.0052

Template load

0.0010

5.3624

0.0010

Template processing

0.0043

24.0278

0.0043

Override

Cache load

0.0007

3.7140

0.0007

General

dbfile

0.0013

7.5477

0.0001

String conversion

0.0000

0.0390

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs