You could download 1000 or 5000 records to the browser... but then
someone has to go through them... no one will... As someone said
(Jeffery) it's just a big pile of records on the floor.
You need to instill a little discipline (with the users) and a
implement good search/drill-down so that the users can quickly locate
a subset of records that they can browse through (next prev)
Sites that barf [specifically chosen term] thousands of records in
response to a query are an insult to the user and an affront to the
web (total waste of bandwidth) IMO.
If you want to see one way to do it, email me off line.
Dick... pissed, but still smiling!
At 6:18 PM -0500 4/11/01, Craig Bowes wrote:
>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
