still waiting for PPN's test...
if it doesnt hold well... i tried at least.. and we still have his version available, right? :)
at least i learned something new about it.

No, remove the illogical code. (the part I was talkin about...)

ok.. :)
illogical.. hehe you made me smile, because i said earlier that i went with the logic.
so what should i do... leave it like that? :it will not show any threads posted yesterday. i tried that first.

Of course it will show threads from yesterday. And if your board is not very busy, the chances two posts would be posted at the very same second are very low, so you can also drop the thread.forumid=forum.forumid part our of the query.

ic... is wierd. i swear i thought the same way. but when wooolF tried the code it didnt work. you think if would be related to some other hacks he installed?

anyway.. i will update the file with the final query listed above. thanks for the help.
btw, do you plan adding it here? vB.org have alot of posts and traffic. probably a good place to see if the query keep everything tight...

ok.. i updated the file.

I'll probably install Scott's, if I decide to add that functionality.

np. one more time thanks, firefly.

It wasn't too bad on my local computer seemed to go fine, but when i put it on my live board with 16 browsing the load time went up and server load jumped from 0.46 to 1.63

ok. thanks PPN. what about your hack?
not that i try to compare. but i'm sure you test it. what are the results for yours? after all, i dont mind at all installing yours on my new board. let me know please.

His hack just adds another field to the forum table, which is already selected so the overload is nil. And since the forum table isn't big (unless you have thousands of forums), another field doesn't matter.