This hack is giving me hope as my very large board often succumbs to slow page loads during very busy times. I just read thru every post in this thread as well as the old 3.5.x thread and there is not a whole lot of success stories listed.
Has anyone noticed significant speed ups on big boards? I would love to hear some specifics on this before I install. I am currently running eAccel so this hack might be a good fit for me.
This hack is giving me hope as my very large board often succumbs to slow page loads during very busy times. I just read thru every post in this thread as well as the old 3.5.x thread and there is not a whole lot of success stories listed.
Has anyone noticed significant speed ups on big boards? I would love to hear some specifics on this before I install. I am currently running eAccel so this hack might be a good fit for me.
BTW the support from orban is phenomenal. Props.
I'm running a (rather) big board myself (1.5 million posts) and I did/do notice a huge performance improvement.
Quote:
Originally Posted by nix
Any answer to this one? Like he said its commented out right now. Should we uncomment this? Or is this basically what the hack does?
The datastore value in config.php has nothing to do with templates or this addon.
Has anyone noticed significant speed ups on big boards? I would love to hear some specifics on this before I install. I am currently running eAccel so this hack might be a good fit for me.
VERY nice, people. We run an extremely busy board, with 6 load-balanced webservers and frequently 2000+ visitors... Watching the slow query log on the MySQL server was painful, since the template query often took more than 6 seconds on a very fast server, and of course, that slowed things down significantly, even causing the SQL server to drop other connections, etc.
This "hack" has made our board a LOT faster, and it's really appreciated. We're running it over NFS, and at first, since NFS doesn't support file locks, we were having some problems, since 0-byte files were being created. However, I found that a crude hack to fix that problem worked well... And for others who have the same problem, here's the crude hack that will fix it:
Replace the following line (around line 29 in 1.03):
Code:
if (file_exists($templatefile))
with
Code:
if (file_exists($templatefile) && filesize($templatefile) != 0)
Pretty simple, but it works. Basically, if the file is a zero-byte file, it will recreate it. If it's not... It won't.
Anyhow, that will fix the little problem created by file-locking if you're running NFS and getting zero-byte files.
And I'd HIGHLY recommend this to anyone who's been watching their slow-query log on their SQL server and getting frustrated with how that damn "SELECT title, template" keeps showing up in their logs. Get it, install it, your worries are over.
As for the datastore, I'd highly recommend that you get memcached set up and installed, that will provide a HUGE boost as well.
VERY nice, people. We run an extremely busy board, with 6 load-balanced webservers and frequently 2000+ visitors... Watching the slow query log on the MySQL server was painful, since the template query often took more than 6 seconds on a very fast server, and of course, that slowed things down significantly, even causing the SQL server to drop other connections, etc.
This "hack" has made our board a LOT faster, and it's really appreciated. We're running it over NFS, and at first, since NFS doesn't support file locks, we were having some problems, since 0-byte files were being created. However, I found that a crude hack to fix that problem worked well... And for others who have the same problem, here's the crude hack that will fix it:
Replace the following line (around line 29 in 1.03):
Code:
if (file_exists($templatefile))
with
Code:
if (file_exists($templatefile) && filesize($templatefile) != 0)
Pretty simple, but it works. Basically, if the file is a zero-byte file, it will recreate it. If it's not... It won't.
Anyhow, that will fix the little problem created by file-locking if you're running NFS and getting zero-byte files.
And I'd HIGHLY recommend this to anyone who's been watching their slow-query log on their SQL server and getting frustrated with how that damn "SELECT title, template" keeps showing up in their logs. Get it, install it, your worries are over.
As for the datastore, I'd highly recommend that you get memcached set up and installed, that will provide a HUGE boost as well.
But with the PLugin Based Template Cache on, the table with the "users who read the thread" doesn't shows. Does anybody knows how could I use both plugins at the same time?
Plugin Based Template Cache Details »»
About Developer
Visit Web Site
Uses Plugins 
No support by the author.
11-12-2006, 11:43 PM
We run an extremely busy board, with 6 load-balanced webservers and frequently 2000+ visitors... Watching the slow query log on the MySQL server was painful, since the template query often took more than 6 seconds on a very fast server, and of course, that slowed things down significantly, even causing the SQL server to drop other connections, etc.
