Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

limit records returned using TOP

Quote Reply
limit records returned using TOP
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
Thread limit records returned using TOP kevin.palmer 3353 Mar 21, 2004, 2:23 PM
Thread Re: [kevin.palmer] limit records returned using TOP
Jagerman 3286 Mar 22, 2004, 1:10 PM
Thread Re: [Jagerman] limit records returned using TOP
kevin.palmer 3274 Mar 22, 2004, 5:25 PM
Post Re: [kevin.palmer] limit records returned using TOP
Alex 3253 Mar 25, 2004, 3:09 PM