Tom Nunamaker wrote:
Nice link Daniel. I completely agree that Access is unsuitable for most people. Microsoft does say you can use it to build a database and upsize it to SQL server, but I've found the tools in SQL server to be more than adequate for developing (with the exception of debugging stored procedures...) Most of the "problems" in that link can be avoided if you put the database outside of the web root and use cachedwithin for most of your CFQUERY tags. I wouldn't have a problem for a new site using Access as the hit counts are generally really really low initially. Of course, if it becomes successful, which you'll know fairly soon, then moving to SQL server is assumed. I don't use Access anymore myself because of TransAct-SQL and stored procedure that I use when building sites. The point was you can use Access as long as you are aware of the limitation. :)
Kind regards,
Tom Nunamaker
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Elmore Sent: Saturday, October 30, 2004 2:43 AM To: [EMAIL PROTECTED] Subject: RE: Data sources
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
----------------------------------------------------------
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
