| « Previous Entry | Next Entry » |
| By rob on Dec 14th 2004, 5:59 am | Permalink |
|
It ain't much, but I made a few changes around here, so maybe it's a start... Added a View by BJCP category to the recipes. Added a prev/next link to the forum. Took a long look at the forum database and indexes and things to try to speed up the query. Read a little about how MySQL optimizes queries. It takes about 1.5 seconds to SELECT 50 threads order by last modified thread and grouping by threads. I played with the keys and it didn't help any. I tweaked the SQL and even with barebones columns it still takes that long. Maybe it's the 26000 messages in the forum. So I think it's as optimized as it can get without changing the underlying structure. I do notice some lag when you hit the forum so this might have to happen in the future. The query caching does seem to help -- if you hit the forum once, then do it again within a few seconds it's faster b/c it's pulling from the cache. -Rob |
|