Right..that's what I thought.
So 71,000 Records is well within the capabilities of CFMX Professional.
Soooo....errmm..why is it blowing as soon as I go over 5,000 Records?
Same syntax everything..only thing that is changing is the Max Rows
attribute, from 5000 to 10000....
Any ideas? Like I said..the server has 1Gig of memory...
------------
<cfquery name="qryGetBusiness" datasource="#DSN#" maxrows="5000"
dbtype="ODBC">
Select * from tblBusiness
</cfquery>
<cfquery name="qryGetResidential" datasource="#DSN#" dbtype="ODBC">
Select * from tblResidential
</cfquery>
<!--- INdex the business and then the residential tables from the two
queries above --->
<CFOUTPUT>Business= #vtyBusiness#</CFOUTPUT>
<cfindex action="REFRESH"
collection="#vtyBusiness#"
key="ID"
type="CUSTOM"
title="BusinessName"
query="qryGetBusiness"
body="BusinessName"
language="English">
-----------------
-Gel
-----Original Message-----
From: Jeff Garza [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 1:00 PM
To: CF-Talk
Subject: Re: Verity
A document would contstitute one row from a database.
Jeff
----- Original Message -----
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 9:53 AM
Subject: RE: Verity
So..to apply this to a database..that means..what?
250,000 Records??
What is a 'document' when applied to a database?
-Gel
______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
