Hi
I've got a client who is interested in purchasing a Miva storefront and we are trying to determine which backend database to use. The Value plan has an Access backend, while the Power plan gives you a choice between Access and SQL.

If my client were to sell shirts, for example, how many shirts could be entered into the Access database before it was full, or slowed down?

Are there any other pros or cons for each database that we need to consider?

Thanks!
Polar

Hi Polar,
You should be able to post as many shirts as you want in either database, provided that you do not go over your disk quota. However, I recommend that you use SQL since Access only allows a certain number of connections at a given time (about 5) and then your database will not allow anymore connections and your site will throw an error. In addition, if you do decide to use Miva, it does use its own databases in the backend.

Hello,
When you consider using one technology over another, especially when it comes to databases, you have to look at the stability of that product. I would not recommend using Access in any moderate to high level store environment. Access is stable up to 5 concurrent connections, and then starts to degrade after that point. Basic sites that need databases are made for access, however, when you get into the higher up databases, using either MySQL or MS SQL is the way to go. They are server based and will run stable with a lot more than 5 connections. Of course, if you have any more questions, let us know.

access can handle about 25 concurrent connections
but i wouldnt trust it to save my life

Actually if you're going to use Miva Merchant then it's a moot point - Miva stores it's products in it's own databases (.dbf I believe) so you don't have to incorporate Access or SQL into the website unless you're going to store a separate list of products or features.

Miva uses its own database, a metabase really, which stores all products and information seperately. It gives you the ability to view the data raw if you need to, but typically it runs pretty seamlessly on its own.

MySQL all the way, it has alot of power when you unleash it. Plus i do not particularly like microsoft products. However like they have said Miva has its own database. (Doesn't miva merchant 5 have MySQL support?)

qleyo,

Now we have MIVA 5 with MySQL support.