Access or MySQL

[nadamson]

Being new to CF I have started by using Access as the database backend to store the dynamic informaiton.

My question is, at wha point does Access's performance start to degrade ?. The database consists of 4 tables with 20-30 records and 1 table with 4000 records and 1 table with upto 50,000 records (although it only has 2 fields and is used for referencing the product).

Any views ?

 

[r937]

depends on the number of simultaneous calls to the database -- more than five a second, and you may have trouble

note that this is not the same as more than 5 people on your web site at the same time -- you can have many, many more people browsing your web site simultaneously, just as long as they don't all hit the search button at the exact same microsecond

if you use coldfusion query caching, you can reduce this exposure significantly, assuming there are queries which return the same results to all users (e.g. get list of categories, etc.)

r937.com | rudy.ca

 

[mansii]

I still use Access in storing small scope of "Metadata" such as menu list and current events. Then, as rudy mentioned, query caching is used for certain amount of time.

Googling out, I found this page listing some limitation of that database:

http://databases.aspfaq.com/database/what-are-the-limitations-of-ms-access.html

Regards

 

[imstillatwork]

Some people will argue that access is NEVER to be used on a web.

It can work if you realize the limitations and plan for it. eventually, traffic and usage will show it's weaknesses.

I prefer the much wider choice of functions and syntax that MySQL provides, or MSSQL. When i switched a site over to mysql a while back, it felt much faster also. maybe not, but it seemed like it.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[CTekMedia]

MySQL is much more robust than Access. I use MySQL on my own ecommerce sites. I prefer MSSQL but it isn't free. At work I use Access for low volume internal databases and SQLServer for everything else.

Cheers,

Bluetone