Page Load Times

[cyberman]

Although it seems a bit slow, it's not _too_ slow (it's still usable). All of my tests were done with a default install, using the demo data

Results:
Generated in 0.22029 seconds by CMS Made Simple (not cached) using 19 SQL queries and 1355680 bytes of memory
Generated in 0.200293 seconds by CMS Made Simple (not cached) using 19 SQL queries and 1355760 bytes of memory
Generated in 0.200231 seconds by CMS Made Simple (not cached) using 19 SQL queries and 1355760 bytes of memory

This is without any caching enabled.

Please test it under real conditions and make a server stress test (10-100 Users) and you will see, why I'm searching for the posted solutions ...

[Pierre M.]

...Please test it under real conditions and make a server stress test (10-100 Users) and you will see, why I'm searching for the posted solutions ...

Yes, I agree with Cyberman. Webcontent broadcasting load is more about serving 50000 requests within a quarter an hour rather than only one request in 0.x seconds. Cyberman's cache hack and CMSms v2 "full page caching" are going to drive CMSms near to static webserver performance (whatever SQL power with zero SQL query, whatever PHP version, whatever OS).
Pierre M.

[biffs]

I've installed the cache tags, but I really don't notice any improvement.

Still taking 1.5-1.9s to load a page.

[Vin]

Have you deleted all you could (unused translations, plugin/tags, UDTs, templates e.g.)?
Maybe using Redux package (in the forge) would help...
Also, Kermit suggests removing the stylesheet from the database into a flat file and link the relation with the tag.
I myself use just these smarty plugins in the smarty library (but I'm still testing the cmsms on the local machine, so there may be problems, and some modules require some of the default smarty plugins)(lib/smarty/plugins):

block.cms_markdown.php
block.textformat.php
compiler.assign.php
function.cycle.php
function.eval.php
function.html_checkboxes.php
function.html_image.php
function.html_options.php
function.html_radios.php
function.html_select_date.php
function.html_select_time.php
modifier.cat.php
modifier.date_format.php
modifier.default.php
modifier.escape.php
modifier.spacify.php
modifier.string_format.php
modifier.strip.php
modifier.truncate.php
outputfilter.trimwhitespace.php
shared.escape_special_chars.php
shared.make_timestamp.php

[biffs]

So let me get something straight - every possible tag, module, language, etc. will slow down CMSms even if its not being used on the page being loaded?

Also, I dont think that the cache is working at all.  In the timer at the bottom, it never says cached.  Its always "not cached"

"Generated in 3.678264 seconds by CMS Made Simple (not cached) using 25 SQL queries and 7206640 bytes of memory"

And why so many SQL queries?  thats comparable to some forum systems, which are completely dynamic.

I've cut the {stylesheet} tag out and replaced them with flat-file css files, and I'm using the {ccontent} tag as well, but its not helping any at all.

I am not using CMSms in a live environment yet because its just so slow. I would love to get this going, but I need load times under 0.5 seconds for it to be any use to me at all.  I am seriously considering using the svn package just for the full page caching if it works as advertised (0.1s loads)

[cyberman]

every possible tag, module, language, etc. will slow down CMSms even if its not being used on the page being loaded?

Yep.

Also, I dont think that the cache is working at all.  In the timer at the bottom, it never says cached.  Its always "not cached"

In older versions CMSms uses Smarty caching. But it slows down performance to much so it was deactivated. It has nothing to do with cache tags.

And why so many SQL queries?

Cause CMSms uses a lot database access - templates, stylesheet, content, GCBs, UDTs and some other stuff - they are all located in database.

[Pierre M.]

And why so many SQL queries?

Cause CMSms uses a lot database access

I'd said : because CMSms v1.0 uses a lot of SQL queries...
(refering to v2.0 full page caching)

Pierre M.

[cyberman]

Have found another nice tuning option  ...

Open /lib/adodb.functions.php with your favourite editor, go to line 56

Code: Select all

$dbinstance =& ADONewConnection($config['dbms'], 'pear:date:extend:transaction');

and add after there

Code: Select all

$dbinstance->clientflags = MYSQL_CLIENT_COMPRESS;

(CMSms 1.0.5 - only for mysql users)