I consult occasionally for a site that uses Interbase - www.evworld.com. I've been reasonably happy with the performance of the DB - especailly since all the code on the site was written by a rank amatuer, and he still manages to get a very usable data driven site together using Interbase. Lots of queries, lots of astericks instead of column names and lots of unecessary data being pulled in... yet it keeps on running with reasonably high traffic too (200000 page views a day or so). That's my 2 cents.
-----Original Message----- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:30 PM To: CF-Talk Subject: RE: JET I know this is getting OT, but I am really curious if anyone has been using Interbase or Firebird... a while ago I heard really good things about Firebird/Interbase. What have been your experiences with 'em, good or bad? If you want, email me off-list, at [EMAIL PROTECTED] Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -----Original Message----- From: Mike Alberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:40 AM To: CF-Talk Subject: Re: JET I think the article you mention gives the answer to 'what's the view in the cf community': "The Access ODBC Driver and Microsoft OLE DB Provider for Microsoft Jet are not intended to be used with high-stress, high-concurrency, 24x7 server applications, such as web, commerce, transactional, messaging servers, and so on." Why use Access at all? If a commercial DBMS isn't a viable solution, why not use MySQL or Postgre or Interbase (or it's open source cousin, Firebird). My .02 -------- >Date: Tue, 29 Jan 2002 15:22:28 +1030 >From: "Parker, Kevin" <[EMAIL PROTECTED]> >Subject: JET >Message-ID: > ><[EMAIL PROTECTED]>.au > >This was drawn to my attention today (extract below) and I >traditionally >use >Access via an ODBC connection for small apps. The full article can be > >found >at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q222135 >******* >When running Microsoft Jet in an IIS environment, it is recommended >that >you use the native Jet OLE DB Provider in place of the Microsoft >Access >ODBC driver. The Microsoft Access ODBC driver (Jet ODBC driver) >can have >stability issues due to the version of Visual Basic for >Applications that >is invoked because the version is not thread safe. As a result, when >multiple concurrent users make requests of a Microsoft Access database, >unpredictable results may occur. The native Jet OLE DB Provider includes >fixes and enhancements for stability, performance, and thread pooling >(including calling a thread-safe version of Visual >Basic for >Applications). ******** >What's the view in the CF Community - should I switch strategies here -> is >this a problem using CF? _________________________ _________________________ _______________ Send and receive Hotmail on your mobile device: http://mobile.msn.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ _________________________ _________________________ ____________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
