Just off the top of my head.....
If you are running a specific query to do this I would set up a scheduled
task to run the query and then cache it
-----Original Message-----
From: Craig Bowes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 April 2001 11:18 AM
To: CF-Talk
Subject: She's got HUGE...... Recordsets
I wanted to get everyone's input on this as I'm sure this is a pretty common
scenario. I have plenty of clients that have e-commerce sites or intranet
sites that need to pull large recordsets. For Example, they might need to
view their inventory so they can edit or delete one record. The problem is,
once the inventory gets to 1000 or 5000 records or more, downloading this as
one big list is unrealistic. I have done the whole NEXT--> 10 records or
whatever (which I hate), and I could also do a search so they can search by
product name or ID. But is there a better way to pull this kind of data and
how do you manage the updates/inserts? Could you use a java/wddx thing to
download the recordset once and then browse it on the client side (I think
Ben Forta's Advanced CF Construction Kit has something like this) and I've
also seen an ActiveX/VBScript version of this.
So what is an easy, intuitive way for the client to manage these large
recordsets and perform updates/deletes?
Please reply to [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> . Any code or
examples would be appreciated.
Thanks,
-Craig
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
