> I have a SQL server 2000 db holding around 50,000 recs. I need to
> select the full 50,000, however CF server eats resources then times out.
> Any way round this??
This usually isn't a CF issue, but the fact that there's so much data being
transferred
What I have to do is get the list of IDs that I want, grab them 1,000 at a
time and add them to a virtual query (using QuerySetCell etc.)
Once you have them all in memory, you can Query a Query to do what you need
I've found that CF5 is less tolerant about talking to database engines than
CF4.5, but the Query a Query function sorts this out
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
