[thelist] SQL Rowcount Problem

Sean G. ethanol at mathlab.sunysb.edu
Fri Jun 21 20:51:01 CDT 2002


Howdy,

It's been a couple years and a couple versions since I was a daily CF user,
but I'm pretty sure there's built-in functionality for just such an
occasion.

You run yer query and cache the record set into memory, then pull out
records as needed, something with startrow and maxrows.

Ah yes, this should get ya going:
http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=414


HTH,

Sean G.



-----Original Message-----
Afternoon, y'all.  I have this problem, see...

I have a query (SQL Server, CF5) that returns up to several thousand
rows as a search result.  Due to the nature of the query, at times it
runs long, and adding to the performance issue (I believe) is the fact
that it returns many columns and many rows of data from the SQL Server
via the network, when I only need to display a few at a time (10-50) to
the user.





More information about the thelist mailing list