Sure, use it if it meets your needs, but be aware of the limitations..
http://www.macromedia.com/support/coldfusion/ts/documents/tn17034.htm Russ > -----Original Message----- > From: Ellwood [mailto:[EMAIL PROTECTED] > Sent: 04 July 2004 18:33 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL compared to Access backend > > 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] > -- 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]
