Query of query - running slower on 64 bit CF than 32 bit CF

greetings...

 

i seeing behavior pages use query-of-query run slower on 64-bit coldfusion 9.01 on 32-bit coldfusion 9.01.

 

my server specs : dual processer virtual machine, 4 gig ram, windows 2008 datacenter server r2 64-bit, coldfusion 9.01. note coldfusion literally "straight out of box", , using default settings - thing configured in cf single datasource.

 

the script using benchmark runs query returns 20,000 rows fields id, firstname, lastname, email, city, datecreated. loop through 20,000 records, , each record, query-of-query (on same master query) find other record lastname matches of record i'm on. note i'm interested in using process comparative benchmarking purposes, , know process written more efficiently.

 

here observed execution times both 64-bit , 32-bit coldfusion (in seconds) on same machine.

 

64 bit cf 9.01: 63,49,52,52,52,48,50,49,54 (avg=52 seconds)

32 bit cf 9.01: 47,45,43,43,45,41,44,42,46 (avg=44 seconds)

 

it appears 64-bit cf performs worse 32-bit cf when doing query-of-query operations. has made similar observations, , there way can tune environment improve 64 bit performance?

 

thanks can provide!

 

 

by way, here's code generating these results:

 

<!--- allrecs query returns 20000 rows --->

<cfquery name="allrecs" datasource="mydsn">

    select * mytbl

</cfquery>

<cfloop query="allrecs">

    <cfquery name="samelastname" dbtype="query">

        select * allrecs

        ln=<cfqueryparam value="#allrecs.ln#" cfsqltype="cf_sql_varchar">

        , id<><cfqueryparam value="#allrecs.id#" cfsqltype="cf_sql_integer">

    </cfquery>

    <cfif samelastname.recordcount gt 20>

        #allrecs.ln#, #allrecs.fn# : #samelastname.recordcount# other records same lastname<br>

    </cfif>

</cfloop>

More discussions in ColdFusion

adobe