Posted: 10/22/2002 3:06:09 PM EDT
|
I'm trying to set up a webstore with an ASP based cart. It came with an Access database and the script to create an SQL database. I've got it running with the Access database now but was told I should change to the SQL type because it will make the store run smoother and the database will load more quickly. As you can see from the post below I'm having difficulty setting up an SQL database. Initially I'll have about 5,000 items in the store and around 100 catagories. Since it's goign to be a new site I'm sure it will be low to medium traffic at the most. What I'm trying to find out is how much difference I'll notice in speed using the Access database versus the SQL one? I don't want the site to run so slow that customers get impatient and go else where. If the Access will work ok for me now then maybe I can start with it, learn the SQL and change to it in the future. John |
|
Access was never intended to handle multiple connections and it will lag if too many users connect at once. When you're just starting out an access DB might work okay, but there are better options. If you are planning on SQL Server in the future then you'd be better served by using MSDE. It is a stripped down version of SQL Server that limits the number of simultaneous connections. The advantage is that since it is still SQL underneath it will be much easier to upgrade in the future. The MSDE engine is free with Access but it doesn't come with the Enterprise Management tools that SQL Server has. If you have those tools available then they can connect and manage MSDE databases just like SQL databases. Since the software you're using came with scripts to build the SQL database that should work for MSDE as well. |