siteCache and loading problems

MySQL: 0.1728 s, 5 request(s), PHP: 4.3515 s, total: 4.5243 s, document retrieved from database.
MySQL: 0.1104 s, 1 request(s), PHP: 4.2945 s, total: 4.4049 s, document retrieved from cache.

ditto2
wayfinder2
table contents 5000
table tvvarscontent 25000

size of siteCache.idx.php 1.5 mb
modx 096
php5 mysql5

os winxp cel
2600
512mb

Is it good?
What should I do to optimize it?

At the moment, there’s not a lot you can do without hacking the core code significantly. The fact is, that is just too many documents and TV’s for the current architecture to deal with, especially on the hardware you are running (though even on massive hardware that would still be a bottleneck). You could look into having the pages cached directly to html using an add-on like the experimental plugin htcache, or a similar concept.

Quote from: OpenGeek at Oct 23, 2007, 03:41 PM

At the moment, there’s not a lot you can do without hacking the core code significantly. The fact is, that is just too many documents and TV’s for the current architecture to deal with, especially on the hardware you are running (though even on massive hardware that would still be a bottleneck). You could look into having the pages cached directly to html using an add-on like the experimental plugin htcache, or a similar concept.

This pluging is’t good for me. Because I usually import all data with price from same csv files.
I think that it’s because cache. How do you think it helps me if I kill siteCache using hack or I should write me one snippets using MYSQL to increase PHP spead?

Quote from: SamZ at Oct 23, 2007, 04:14 PM

This pluging is’t good for me. Because I usually import all data with price from same csv files.

I don’t understand how that has anything to do with using this plugin. When you update the pages, you’d simply clear the generated HTML files and have them regenerate themselves again.