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
