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]
