|
Date: 5/22/2007 12:57 pm · Subject: Re: Fix: Thread template: next.url and previous.url tmpl_vars are always defined · Rating: 0
Instanciating the asset takes 0.0079 seconds. Running the nasty query to figure out what the next/prev thread is on a big CS takes 4.1874 seconds. This morning one of my sites was causing one of my servers to have a load average between 15 and 40. It turned out this was because of two reasons. One the site was getting hammered by search engine bots because some new sites started linking to this site. The second reason was that this site is entirely made of collaboration systems with thousands and thousands of threads, and this code was causing a big load. After removing the code you put in there for the check the load dropped to 3. Granted, that's still not good, but it's a lot better than 15 or 40. That's how inefficient that query is. I've tried to figure out how to make it faster, but I haven't come up with anything. So, for the time being, I'm afraid that the previous/next functionality has to remain as is until someone comes up with a super efficient query for determining previous/next. As for it causing another bug someplace else. It may. But until it's confirmed and reported, I have bugs to fix that have actually been confirmed and reported.
|