Derrick-
Are you executing one query in CF, then feeding the resulting dataset
back into another CFQUERY tag? If so, you are essentially pulling a
huge dataset into CF and feeding the entire thing back into another
query, which would be understandably slow.
Does this not accomplish the same
Yeah, why not join the table to itself. It should be faster than a
subselect, which is the other option.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Free speech exercised both individually and through a free press, is
a necessity in any country where people are themselves free.
On 9/7/06, Cameron Childress [EMAIL PROTECTED] wrote:
Does this not accomplish the same thing?
Heh - I accidentally deleted what I put here, but it was essentially a
subselect. A self join as Dean suggested also might work.
The key is just to minimise the data MySQL and CF have to shuttle
Would that still be the reason for the huge slowdown between php and
CF? I would think there would be something else there causing that...
just curious.
On 9/7/06, Cameron Childress [EMAIL PROTECTED] wrote:
On 9/7/06, Cameron Childress [EMAIL PROTECTED] wrote:
Does this not accomplish the same
I have a database with 2.3 million records, one table, 9 fields, optimized as much as possible (enum is used where possible, and other tips, also no nulls). MySQL 4.1.13 is the DB with the JDBC 3.1.7 driver.My problem is that to get the record I need, I have to look up the record based on a value