HUH??? Ok there is something to be said for SQL or Oracle servers, but I
can speak from experience when I say that if the CF code is tight that
Access can be used just fine for some pretty busy sites. I did a site that
does a million plus users a month and it's all powered by two Access
databases with ODBC and it's never been a problem. We just kept tweaking on
the CF Code and the table until we had it running just like we wanted. If
you cache your queries or scope them correctly and cut down on how much you
hit the database you can use Access like you would not believe and it will
be plenty nice to you.
On the same token, I have seen clients that think by switching from Access
to SQL server they will see huge gains in performance. But again I say if
you don't write your CF tight you will not see a thing. It comes down to
understanding what will do what and how to leverage it to your advantage the
best way you can. If you don't write clean code Access, SQL Server, MySQL
none of them are going to do what you want. I can tell you that poorly
written code will kill you more often then a database problem if that end is
designed correctly also.
Ok, I am done now just my .02 on it.
Bill
<cf_warrior>
> ><RANT>
> >I'm amazed at the amount of posts I see on this list by people
> >mentioning that they are running with MS Access. When you do
> >this, don't be surprised when you have problems. I've talked to
> >Allaire on the phone and they've told me that they reccomend
> >that you never use Access in a production environment. Access
> >is a single user database. Not something to hook in to the web!
> ></RANT>
> >
> >RPS
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
