I have two files, one that only queries some data, another that querries
it and displays it. My execution time though is terrible when I try to
display it. Does anyone know what may cause this hit in performance?
This is the one that just querries the data:
mytest (Datasource=aphlink, Time=6ms, Records=9) in
/usr/local/projects/vlsi/qctweb1/dev/ray_ex/test.cfm @ 11:02:09.009
Here is the code for this page:
<cfquery datasource="aphlink" name="mytest">
select mem.*
from qbs_ml_email_addrs mail, qbs_ml_members mem
where mail.email IN ('mikezgroup')
and mail.id = mem.id
</cfquery>
This is the one that querries and displays the data:
mytest (Datasource=aphlink, Time=119742ms, Records=9) in
/usr/local/projects/vlsi/qctweb1/dev/ray_ex/test1.cfm @ 11:00:10.010
Here is the code for this page:
<cfquery datasource="aphlink" name="mytest">
select mem.*
from qbs_ml_email_addrs mail, qbs_ml_members mem
where mail.email IN ('mikezgroup')
and mail.id = mem.id
</cfquery>
<cfoutput query="MyTest">
#id#--#email#<br>
</cfoutput>
Ray Bujarski
Direct 858-845-7669
Pager 858-636-9900
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
