On Sat, Jan 5, 2013 at 8:25 AM, Russ Michaels <[email protected]> wrote:
> 2 simple solutions are. > > 1. Dont query all the data at all, instead provide a search form to get at > specific records, which is usually much simpler thsn paging through > hundreds or thousands of records. > 2. Only query the primary keys, and then loop over that list grabbing x > records at a time and doing a new query to get all rows for those keys. > If you know you are going to have huge datasets shouldn't you also use blockfactor? my assumption is that while it might not speed things up, it's at least clearing things out of buffer while it works on more records. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
