First the Database is Oracle9i on an independent system. I run the following query on Coldfusion 4.5x (with the latest revision/patch) on Windows2000/IIS5. The hardware is an old Dell dual pentium pro system with 512 MB.
qryReport (Records=864, Time=234ms) SQL = SELECT LEVEL, id, pid, keyword, SYS_CONNECT_BY_PATH(keyword,'/') as path FROM ndx START WITH id = 1 CONNECT BY PRIOR id = pid ORDER BY path I run the same query on ColdFusionMX on Solaris 8/Apache 2.0.40. This hardware is a Sun system (450's is what I call) with at least 2 processors and over 1 gig of RAM. I'm not really sure on this. qryReport (Datasource=archives_metcalf, Time=903ms, Records=864) in /global/apachedg/apache/websites/sitename/wwwroot/archives/metcalf/reports/reportndxoutline.cfm @ 17:00:43.043 SELECT LEVEL, id, pid, keyword, SYS_CONNECT_BY_PATH(keyword,'/') as path FROM ndx START WITH id = 1 CONNECT BY PRIOR id = pid ORDER BY path What give? The query on the system with ColdFusion MX takes at least 3 time longer. Am I missing something here? Now I know someone is going to come back and say their are too many variables. But come on, pentium Pros against this honking 450 Sun System? But for the benefit of the doubt and If I can get some time, I'm going to try MX on the Pentium Pros and see if I see anything different. But I doubt it. Are others experiencing similiar slow downs? -- ------------------------- Troy Simpson Applications Analyst/Programmer, MCSE, OCPDBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
