caching / performance

Author Message

Georg Franz

Saturday 28 February 2004 7:41:40 am

Hi,

some thoughts about performance of ez:

ez2 had a performance problem with doing a lot of queries (e.g. the getTree methods), but was very fast with template processing.

At ez3, it's vice versa - the query amount was dramaticly reduced, but the template processing is very slow. Now the ez crew is working hard on the new "template compilation feature" which is very unstable at the moment.

Next problem: The amount of cache-files.

At my installation, "clearing the cache" is a big challenge for my server (clearing the cache completely lasts 60 up to 120 seconds)

And after that, the challenge is even bigger: recreating the cache.

And - if you have "luck" - two or more spiders crawls your site right at the moment you are clearing the cache and causes a lot of unique page views. So the you can't speak of "performance" anymore, "slowness" is the better word ;-)

I've made some thoughts, one idea is:

Why using cache-files? Why not using the database for caching (add one or more "cache-tables")? Has anybody of the ez crew tried this?

Advantages:
-) Reduces the "cache-files" to a minimum
-) A better Cache-Handling is possible

Kind regards,
Emil.

Best wishes,
Georg.

--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

Björn Dieding@xrow.de

Monday 01 March 2004 5:54:41 am

Maybe it would be wise to layout your advantages a little more.

I see some disadvantages

-a php accelerator won't work with those cached file
-you will notice a slow db server because of the many writes and reads to the db.
-the db server will use more ram
-hitting a single file on the disk is usually faster then selecting a row from the db

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Georg Franz

Monday 01 March 2004 1:01:13 pm

Hi Björn,

yes - I know your points, but that's the theory. Has anyone tried it?

At my installation, the "template load" takes 40% - 60% of the performance.
The sql queries (there are 9) takes 0.01%.

The big rest is "template processing" which should be better, if the template compilation feature is ready to use.

If the ez cache is empty, around 300 queries takes 0.9% up to 1.5% of the total performance.

You can't use a php-accellarator at a large installation for the ez cache files. (Too many files.)

Kind regards,
Emil.

Best wishes,
Georg.

--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 22:19:21
Script start
Timing: Jan 18 2025 22:19:21
Module start 'layout'
Timing: Jan 18 2025 22:19:21
Module start 'content'
Timing: Jan 18 2025 22:19:21
Module end 'content'
Timing: Jan 18 2025 22:19:21
Script end

Main resources:

Total runtime0.0189 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0078 592.4766152.6094
Module start 'layout' 0.00780.0038 745.085939.4141
Module start 'content' 0.01150.0053 784.500093.3047
Module end 'content' 0.01680.0021 877.804734.3047
Script end 0.0189  912.1094 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002814.9008140.0002
Check MTime0.00126.3702140.0001
Mysql Total
Database connection0.00147.350910.0014
Mysqli_queries0.003518.712930.0012
Looping result0.00000.142310.0000
Template Total0.00178.910.0017
Template load0.00094.757510.0009
Template processing0.00084.109210.0008
Override
Cache load0.00063.278310.0006
General
dbfile0.00147.518480.0002
String conversion0.00000.054140.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs