Re: CF 5 Oracle Best Pactices
We've used Oracle with CF 4.5 SP2 for a while - I'd recommend going with Oracle 8i (8.1.7) and native drivers. BTW, one of the 8.1.6 Oracle drivers (8.1.6.2 ?) has a memory leak. Chris Norloff -- Original Message -- From: Robert Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 24 Mar 2003 16:25:39 -0500 I'm about to configure a CF 5 machine and was wondering if anyone knows the best version of Oracle to use with CF 5 - 8.0 vs 8.1.6 or 7 and if I should use native or ODBC. Any insight into best practices or experiences is appreciated - TIA! Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 5 Oracle Best Pactices
We've used Oracle with CF 4.5 SP2 for a while - I'd recommend going with Oracle 8i (8.1.7) and native drivers. BTW, one of the 8.1.6 Oracle drivers (8.1.6.2 ?) has a memory leak. Chris Norloff -- Original Message -- From: Robert Shaw [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 24 Mar 2003 16:25:39 -0500 I'm about to configure a CF 5 machine and was wondering if anyone knows the best version of Oracle to use with CF 5 - 8.0 vs 8.1.6 or 7 and if I should use native or ODBC. Any insight into best practices or experiences is appreciated - TIA! Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 5 Oracle Best Pactices
Well, from an Oracle standpoint, 8.1.7 is the only RDBMS that is still supported by Oracle (except under their extended contracts). 9i offers some good things with administration tasks, but, if you're interested in an 8x solution, my vote would be 8.1.7. As far as native vs. OBDC, I would use Native, since I remember (at least back in the days of CF 4.01) that Native drivers were faster than ODBC. That may be different now, but I always try to use native if available. FWIW, -lincoln -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:26 PM To: CF-Talk Subject: CF 5 Oracle Best Pactices I'm about to configure a CF 5 machine and was wondering if anyone knows the best version of Oracle to use with CF 5 - 8.0 vs 8.1.6 or 7 and if I should use native or ODBC. Any insight into best practices or experiences is appreciated - TIA! Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 5 Oracle Best Pactices
we use 8.1.7 solely and extensively. We are using the Micrsoft ODBC drivers too. We get good results and stability. We use the native drivers only if we need to mess with CLOBS. A Ray Thompson on this list or the CFDJLIST said he has done abit of testing and found the M$ drivers good. YMMV DOUG -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:26 PM To: CF-Talk Subject: CF 5 Oracle Best Pactices I'm about to configure a CF 5 machine and was wondering if anyone knows the best version of Oracle to use with CF 5 - 8.0 vs 8.1.6 or 7 and if I should use native or ODBC. Any insight into best practices or experiences is appreciated - TIA! Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 5 Oracle Best Pactices
I've found bugs with the Oracle odbc drivers (version 8.1.7.0). With some data I'd get cursor errors. After upgrading to MX and using native jdbc drivers, I am no longer experiencing these errors. I suggest you use native drivers- the ODBC drivers were buggy for me. Also, 8.1.7.0 is a good idea because for reasons stated below. -Original Message- From: Lincoln Milner [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:46 PM To: CF-Talk Subject: RE: CF 5 Oracle Best Pactices Well, from an Oracle standpoint, 8.1.7 is the only RDBMS that is still supported by Oracle (except under their extended contracts). 9i offers some good things with administration tasks, but, if you're interested in an 8x solution, my vote would be 8.1.7. As far as native vs. OBDC, I would use Native, since I remember (at least back in the days of CF 4.01) that Native drivers were faster than ODBC. That may be different now, but I always try to use native if available. FWIW, -lincoln -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:26 PM To: CF-Talk Subject: CF 5 Oracle Best Pactices I'm about to configure a CF 5 machine and was wondering if anyone knows the best version of Oracle to use with CF 5 - 8.0 vs 8.1.6 or 7 and if I should use native or ODBC. Any insight into best practices or experiences is appreciated - TIA! Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4