Hi all, I have a database with 170K records. What I'm doing is using CF to
query this data with a blockfactor attribute.
cfquery name=qry_selectContacts datasource=#getVars().dsn#
blockfactor=#arguments.maxRows#
I have my loop doing.
cfloop query=qry_getRecords
, July 05, 2006 4:23 PM
To: CF-Talk
Subject: CF crashing SQL 170K
Hi all, I have a database with 170K records. What I'm doing is using CF to
query this data with a blockfactor attribute.
cfquery name=qry_selectContacts datasource=#getVars().dsn#
blockfactor=#arguments.maxRows#
I have
To: CF-Talk
Subject: CF crashing SQL 170K
Hi all, I have a database with 170K records. What I'm doing is using CF to
query this data with a blockfactor attribute.
cfquery name=qry_selectContacts datasource=#getVars().dsn#
blockfactor=#arguments.maxRows#
I have my loop doing
It's a common problem to do pagination on the client (in this case CF)
instead of the database server - it's easier, but as your dataset grows it
becomes very performance intensive.
Pagination in MSSQL is diffucult because you don't have the flexible LIMIT
clause of MySql/Oracle. It's doable,
Does anyone have any ideas on how I can speed up the
process? I have a feeling I need to do something in SQL but I
don't know what to do. How come with the blockfactor it still
seems to be trying to retrieve all the data?
The BLOCKFACTOR attribute has absolutely nothing to do with the
jjbgotty [mailto:[EMAIL PROTECTED]
Sent: 05 July 2006 21:23
To: CF-Talk
Subject: CF crashing SQL 170K
Hi all, I have a database with 170K records. What I'm doing is using CF to
query this data with a blockfactor attribute.
cfquery name=qry_selectContacts datasource=#getVars().dsn
6 matches
Mail list logo
