Good article Tom. Here's a link I refer people to when they don't understand why access should not be used as a datasource.
http://www.aspemporium.com/tutorials.aspx?tid=12 - Daniel Elmore -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Nunamaker Sent: Friday, October 29, 2004 6:57 PM To: [EMAIL PROTECTED] Subject: RE: Data sources That depends on whether or not you can cache everything.. :) If it's just read only, load it in RAM and off you go. Remember when Toys-R-Us had a CF site that loaded their entire catalog structure into the application scope??? Kind regards, Tom Nunamaker -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Woodward Sent: Saturday, October 30, 2004 12:10 AM To: [EMAIL PROTECTED] Subject: Re: Data sources Access is not meant to be and was never meant to be a multi-user database system. Even MS admits that. Using it as a backend for a web site that gets even moderate traffic is asking for trouble. It's not a question of whether or not it will blow up, it's a question of when. If the choice is between Access and SQL Server, there is no real choice other than SQL Server. Getting off Access is 110% necessary. On Fri, 29 Oct 2004 15:06:20 -0700, Colin Wilson <[EMAIL PROTECTED]> wrote: > In this case - the first two options are access or sql 2000... The > mysql is a possible but most likely we'd go for sql... Just trying to > get a bit more info to use in convincing the company that the > development time to convert to sql is necessary. > > Colin > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Jacob Cameron > Sent: October 29, 2004 3:01 PM > To: [EMAIL PROTECTED] > Subject: RE: Data sources > > The person said 'read only data', so not having backups is OK and > mySQL runs much faster for that type of system. > > Heck, I'd use mySQL and cache the heck out of your webserver. The > database choice doesn't really matter as long as you are just reading > data. > > Jacob > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Tom Nunamaker > Sent: Friday, October 29, 2004 4:51 PM > To: [EMAIL PROTECTED] > Subject: RE: Data sources > > I know mySQL is improving, but the last time I looked at it, it didn't > have many features that a robust DB server has: Stored procedures, > views, UDF's, etc. What's the reasoning someone wants to use mySQL? > > Tom Nunamaker > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Colin Wilson > Sent: Friday, October 29, 2004 11:29 PM > To: [EMAIL PROTECTED] > Subject: Data sources > > Does anyone have specifics about the best database to use for cold > fusion.. Currently our site uses access as the database but I could > set up SQL2000 - one of the guys at the company would rather use > mysql... > > So of these - for fast response with lots of requests per minute.... > Basically in a read only situation... Which database would be our > best. > > All three are available options. > > Colin > > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
