I agree with Peter & Jim... browsing through 125K records in any size
chunks doesn't make any more sense than counting chad.
But, that doesn't mean someone won't try to do it!
I suggest you put something in your input form to prevent someone
submitting such a search (e.g., a javascript routine) and also
something in your template which does *not* allow the user to browse
through an unreasonably large record set.
Dick
At 2:20 AM -0700 11/19/00, Jim McAtee wrote:
>I agree with Peter's comments. This problem doesn't make much
>sense. No one is
>going to scroll through a recordset of 125,000 records one page at a time.
>Let's see, at 25 records per page, the chances of finding what you might be
>looking for is 1/5000! What kind of an application is that? I've
>seen similar
>applications on some web sites. You're presented with a screen of maybe the
>first 25 alphabetical records and some text like '1 to 25 of 637 items'. Then
>there's no way to jump to page 10 and no way of having the system
>present, say,
>200 records per page. I can't see many users putting up with that.
>
>Nonetheless, I would think something like the following might work
>in this case:
>
><cfquery name="myquery" datasource="#mydsn#">
>SELECT TOP 25 *
>FROM mytable
>WHERE somefield > #thelastone#
>ORDER BY somefield
></cfquery>
>
><!--- Note the last item retrieved --->
><cfif myquery.recordcount>
> <cfset thelastone = myquery[myquery.recordcount].somefield>
></cfif>
>
>Pass that value along as a starting point for the next page.
>
>Jim
>
>
>-----Original Message-----
>From: Paul Mone <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Date: Saturday, November 18, 2000 10:05 PM
>Subject: RE: scaleability of <cfoutput maxrows=x>
>
>
>>Maybe you could do this?
>>
>>SELECT TOP 25 *
>>FROM TABLE
>>WHERE IDField NOT IN (#List_Of_IDs_Viewed_Already#)
>>ORDER BY SomeField
>>
>>You could keep track of all the ids you've viewed already and store them in
>>a hidden form field?
>>
>>Hmmm. At the end you'd have a list with 124,975 IDs in it. I guess that
>>sucks.
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
