part of the problem is is because even though you are doing 50 per page I bet your query grabs ALL the records each time, which means CF and the database gets hammered by search bots.
there are 2 ways round this and to also provide better performance overall.. 1. cache the recordset and use the startrow and maxrows attributes of cfoutput. 2. write a query that only gets the records you need, can be complex in some database systems 3. require users to provide a search filter -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
