In particular:
CFOUTPUT - StartRow and Maxrows attribues.
CFQUERY - CachedWithin attribute
I would either cache the query or store it in a scope. Then output the records you require using startrow (= (page num -1) * 100) and maxrows (= 100).
Aaron
----- Original Message -----
From: cf coder
To: CF-Talk
Sent: Thursday, July 29, 2004 8:25 PM
Subject: The search is killing the server. Please help!
Hello everybody, I'm working on a logging system. The site search as you can imagine is very complicated and a lot depends on it.
I have written a stored procedure for the search to make the search quicker with a lot of inner and outer joins (the usual). The seach is very quick most of the times, but if the search returns say for ex 5000 + records, it takes a while for it to display the results in the browser. I have impletemented "paging", the search displays 100 records per page and then you have the prev and next links to choose from. I'll give you an example to hopefully give you a better understanding.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
