The text below is an excerpt from an article on database selection on the Macromedia site pertaining to Cold Fusion MX usage in constructing a shopping cart - - the author states below that "database servers are the way to go for the web" - does this mean that i am handicapped using A5 instead of SQL server or the like with Cold Fusion MX?
Kevin Ward
Dallas, TX
_____________________________________
Choosing What's Best For You: File Database or Database Server?
Let's help make this part a little easier. With the exception of Microsoft Access, all file databases are pretty much useless when it comes to delivering dynamic web content�in spite of what the ads might say. Save yourself a great deal of time and trouble and accept this fact right now.
Speaking of Microsoft Access, believe it or not, the most common database on the web is Microsoft Access. The database engine in Microsoft Access 2000 was significantly improved and for a small, low-traffic sites; Microsoft Access does an admirable job. Additionally, Access is a true relational database and supports views. But it has its limitations. It simply cannot handle heavy traffic. If your site traffic is likely to generate more than 20 concurrent database hits at a time, it's time to move to a database server like Oracle, SQL Server, or MySQL (if you don�t need a relational database). Generally, database servers are the way to go for the web.
Kevin Ward
Dallas, TX
_____________________________________
Choosing What's Best For You: File Database or Database Server?
Let's help make this part a little easier. With the exception of Microsoft Access, all file databases are pretty much useless when it comes to delivering dynamic web content�in spite of what the ads might say. Save yourself a great deal of time and trouble and accept this fact right now.
Speaking of Microsoft Access, believe it or not, the most common database on the web is Microsoft Access. The database engine in Microsoft Access 2000 was significantly improved and for a small, low-traffic sites; Microsoft Access does an admirable job. Additionally, Access is a true relational database and supports views. But it has its limitations. It simply cannot handle heavy traffic. If your site traffic is likely to generate more than 20 concurrent database hits at a time, it's time to move to a database server like Oracle, SQL Server, or MySQL (if you don�t need a relational database). Generally, database servers are the way to go for the web.
Comment