I'm using the supplied Oracle driver that came with ColdFusion MX Enterprise. I assume that is not the same ones you are referring too, huh? Where can I find more information about installing these OCI drivers.
Thanks, Troy Sean A Corfield wrote: > What database driver are you using with CFMX? Have you tried installing > the OCI drivers? > > On Wednesday, Oct 16, 2002, at 15:01 US/Pacific, Troy Simpson wrote: > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
