manola, you realize how intense is your query to the server, right?
You are doing a huge scan (very bad), even if you stick to indexes only. If you have 1000 members browsing that page into a large forum, it will kill the server instantly, with average loads going over 30-40 easy. Especially if you run Apache (who is known to eat memory like an elephant).
Always use a dateline, when you play with thread or post tables. Give the smallest value possible to it, then you will be ok.
03-30-2007, 05:22 AM
Threaded Mode