First, I think cached queries are held in Virtual memory and rolled out
to disk -- so the normal memory management of the OS should handle this
efficiently.
Second, I have heard that cursors are things to avoid if you can (like
storing images in a db) because they are resource hogs.
Third, I have used cursors in MS-SQL for very specialized purposes and
the worked well, with little impact on the host.
The specialized purposes are low usage or infrequent utilities such as:
interactively querying/manipulating a database with a SQL tool during
design ot testing
moving a large database from one remote host to another where I
did not have admin privileges on either host
The way I used cursors was bu accessing ADO through cfobject.
HTH
Dick
On Saturday, August 3, 2002, at 01:59 PM, Brook Davies wrote:
> Hello y'all,
>
> In an application which allows forward / backwards browsing of large
> recordsets (10,000-25,000) and access to individual records details,
> how is
> this best handled with CF?
>
> I am currently caching the query and then displaying the rows within
> each
> screen. But this means that the large recordset is held in memory, and
> this
> seems a bit inefficient. Is there a better way to browse records like
> this?
> I've heard MSSQL Cursors might be a solution to this problem. Does
> anyone
> know of CF/CURSOR resources? Is this a good/bad idea?
>
> Thanks for your input.
>
> -Brook
> Brook Davies
> President
> maracasmedia inc
> www.maracasmedia.com
> logiforms / logiworks software inc.
> www.logiforms.com
>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
