Are you all too blinded by prejudice to listen to a reasoned argument. Sure SQL Server knocks the pants of Access. There is no doubt in that what so ever. And yes, when Access gets a load on it its is about as stable as Ahmed's sanity on Big Brother. But what you are forgetting is that A] not every web site owner stretch to a SQL Server environment and B] Not everyone is running a site taking 3000 hits an hour.
As I said, horses for courses. If you are advising your clients to use SQL server blindly without analysing there set up and studying their anticipated growth along with appreciating their budget then you are lax in your responsibility to them. You can recommend SQL server as the best solutions because it is the best solution but I would love to have a Ferrari on my driveway but I only have a Nissan. Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 04 July 2004 18:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL compared to Access backend Your having a laugh? Access can only handle 1 simultaneous connection comfortably as it is a single file desktop database, and if you put an access db under load on a website with too many connections, it will fall over, so will the ODBC driver on CFMX, plus you are likely to get corruption. The bigger the database gets the slower it gets and the more prone to corruption. It was never meant to be used in a web environment, people just use it because they can get away with it. SQL Server/MySQL are database servers, capable or serving up thousands of simultaneous requests, and remain fast even on large databases. Plus all the stuff Neil said. > -----Original Message----- > From: Ellwood [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 22:21 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL compared to Access backend > > Other than database performance (which in my my experience is > not too greatly different in either) the only real > improvement between sql and access is stored procs (which are great). > > Ellis C Wood BSc > > Ellwood Web Solutions > > > > T: 01623 459973 > > E: [EMAIL PROTECTED] > > W: http://www.ellwoodwebsolutions.co.uk > > > -----Original Message----- > From: Jolly Green Giant [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 01:40 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SQL compared to Access backend > > So how different is your code when your backend is SQL Server > rather than Access? I've worked in Access for 4 years. What > can I expect to be different if I want to work in SQL? Most > simple queries will stay the same, won't they? > > I know some functions may change, but what else? > > Thanks! > > David /jgg > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
