Bzp Speed
Techie geeky alert.
I've spent some significant time over the last few days trying to get BZP to run faster. After much analysis and trolling technical forums, I may have found something. I knew that repairing and optimizing the database would help, as would regularly flushing the query cache, which I've done by hand on occasion. But it looks like you really get a bang for your buck by optimizing the entire database and not just some tables.
I finally got sick of sitting by the computer at 2 a.m. every month, waiting for the optimization to finish, so I wrote a PHP script to wander down through each of the 156 database tables that make up the core of BZP. Each table is optimized, repaired, and flushed. Then the entire database's query cache is reset.
With the exception of the "posts" and "topics" tables (which each take at least an hour, sometimes two, to optimize), I just spent 15 minutes running the script. The site, with about 400 people on right now, seems to be running very quickly. As in, much more quickly than it has in a long time.
If this is what it takes, I'll just make sure this script is run regularly, say every week or so. And I know I said I've fixed this before, but I'm really, really hoping this helps solve this bloody latency issue. It's the single biggest nag I've got about BZP.
End techie geeky alert.
15 Comments
Recommended Comments