I have a forum with ~90,000 posts and would like to limit the number of posts that are displayed in the forum view and via the search tool to a more manageable number. I would like to lessen the server load and speed up page loading, and it's obviously unneccesary to display all 90,000 posts to each forum user anyway as no one is going to look through the vast majority of those posts directly. I don't want to delete any posts, but rather only display the most recent X posts or threads. I suppose I'm looking at adding a TOP command to some select statements, but I fear that once i get into it, i'll find that i have to change alot of select statements. Suggestions? Thanks!
Subject | Author | Views | Date |
---|---|---|---|
limit records returned using TOP | kevin.palmer | 3398 | Mar 21, 2004, 2:23 PM |
Re: [kevin.palmer] limit records returned using TOP | Jagerman | 3328 | Mar 22, 2004, 1:10 PM |
Re: [Jagerman] limit records returned using TOP | kevin.palmer | 3315 | Mar 22, 2004, 5:25 PM |
Re: [kevin.palmer] limit records returned using TOP | Alex | 3295 | Mar 25, 2004, 3:09 PM |