VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Database Access / MySQL / MS SQL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

108 Posts

Posted - November 09 2008 :  04:05:48  Show Profile  Reply with Quote

I'm wonder which database use with vp-asp:

in your opinion an ecommerce with 200/250 items which database is better to choose?

Is Access appropriate in order to manage this number of items ?


Senior Member

United Kingdom
1898 Posts

Posted - November 09 2008 :  07:49:23  Show Profile  Visit devshb's Homepage  Reply with Quote
Access is definitely good enough for 200/250 items; it's only when you start to get to around 50,000 or more records in a table or if you get a large number of visitors that you'd need to consider moving to mysql or sqlserver.

Also, with access it's much easier to setup a test database compared to sqlserver/mysql because you just copy the mdb file.

I'd definitely use Access if I were in your shoes. Remember that you can always upgrade to sqlserver or mysql later on if you need to; vpasp has all the relevant conversion/creation scripts to do such a migration if needed later on.

Simon Barnaby
[email protected]
Web Design, Online Marketing and VPASP addons
Go to Top of Page

VP-ASP New User

108 Posts

Posted - November 10 2008 :  05:03:23  Show Profile  Reply with Quote
Thank you Simon for your suggestion.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000