Quote:
Originally Posted by MPDev
Just curious about adding that to the query; does that speed up the query or is it to just make sure you only grab something from the past day?
|
Without the date cut, you scan the hole tables for threads/posts, then you simply select the first 10.
That's really bad, if you have a huge board, it could bring your server to it's knees... very easy.
The date cut will lower A LOT the table scans, because you select only a small segment of threads/posts.
So yes, it is a performance increase.
I made 2 comments there at the top, to explain how to set the date cut, depending on how busy is your board.