This is what I'm trying to get away from. This is just outputting a subset
of my entire recordset.
If I've got a query that returns 125,000 records and only display 25 of
them, it's a waste of the servers resources.
Michael
"Shawn McGehee" <[EMAIL PROTECTED]> wrote in message
015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
> <cfoutput query="myquery" startrow="26" maxrows="25">
> blah blah blah
> ...
> </cfoutput>
>
> --Shawn McGehee
>
> ----- Original Message -----
> From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, November 17, 2000 2:16 PM
> Subject: scaleability of <cfoutput maxrows=x>
>
>
> > I'm working on an inventory management system for a small subset of out
> > product database (only about 3k records compared to about 125k records).
> > When returning the recordset, I want to break it up into bite sized
> chunks.
> > Only problem is, using <cfoutput query="myQuery" maxrows=25>, the query
is
> > still returning about 3k records and only displaying 25. If this thing
> ever
> > gets to the point where I need to keep track of the entire product list
> > (125k records), this is going to bog down things.
> >
> > Is there a way in SQL to set a start row for a query? I know I can use
> 'set
> > rowcount 25' to only get 25 records, but I then need to start again at
row
> > 26.
> >
> > Am I looking in the wrong place? Is there a different way of getting x
> > records and then next x records on the SQL side?
> >
> > Oh, and I can't persist the data in a array of structures or wddx packet
> > because it is inventory that changes quickly and needs to be accurate on
> the
> > execution of the query.
> >
> > Michael
> >
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
