[cedivad]

Thanks for the replies.
vBulletin by default have the index for "dateline" already setted. I noticed that the query takes 0.5 second only the second time i try it, the first the result is

25 rows in set (5.60 sec)

Witch is really bad.

I can't cut the topics older than a week, since that i should order it by dateline ASC, that was only an example.

This is the example where the query is executed: http://it.narkive.com/c/1082 (loading 250 topics instead of 25 don't take any longer!). As stated above, the first time takes a long time (let's say 5 sec) while the second the query is cached so it's faster, (let's say 0.5 sec).

Thank you