Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Customization
 Access, MySQL, or MSSQL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

frelun
Starting Member

Sweden
10 Posts

Posted - March 04 2010 :  14:53:17  Show Profile  Reply with Quote
I wonder what the big difference is between using different databases. Are there any rule about when to use SQL instead of Access. Number of simultaneous visitors, traffic, etc.. What is recommended and when.

Just getting started with VP-ASP.
Thanks, Fred

devshb
Senior Member

United Kingdom
1904 Posts

Posted - March 04 2010 :  16:35:31  Show Profile  Visit devshb's Homepage  Reply with Quote
If data/traffic volumes aren't an issue then use access.

Generally access will deal with up to around 50,000 records in a given table before it starts to crumble (bear in mind that something like prodcategories holds matrix data, so if you have a complex/large category tree and a fair amount of products then your prodcategories table will end up quite large)

Access is the easiest to play around with because you can copy the physical file and easily create test areas/databases etc.

If you have large volumes then you'd use MySQL or SQLServer.

SQLServer has some nasty bugs in it (nothing to do with vpasp, and default vpasp isn't effected by it, but it's something to watch out for if you ever need to change your tables) - see info pages here:
http://www.bigyellowzone.com/support/issue_view.asp?ID=703
http://www.bigyellowzone.com/support/issue_view.asp?ID=327

and SQLServer Table Size calculator here:
http://www.bigyellowkey.com/mysoftware_product_details.asp?prdid=321&opu=n

For the reasons of those SQLServer bugs, I'd tend to veer towards MySQL Instead of SQLServer if I needed a large database.

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
www.BigYellowKey.com
Follow us on Twitter: http://twitter.com/bigyellowzone
Web Design, Online Marketing and VPASP addons

Edited by - devshb on March 04 2010 20:21:32
Go to Top of Page

ironhawker
VP-CART Super User

USA
260 Posts

Posted - March 05 2010 :  16:36:40  Show Profile  Visit ironhawker's Homepage  Reply with Quote
Access and an FTP client gives you a lot of control of the Development Phase of your project.
Once you are up and running you will get an added degree of security and proection for your customers by propigating to an off-site database like MSSql or MYSql.
With PCI comliance required in the US and the hackers getting better it is good for you to try all protection methods available. Depending on your webhost there are clients available to backup and monitor / manage your online secure databases.
Also with large product lists the Sql is better

~-~-~-~-~-~-~-~-~-~
Randy "RC" Corn
[email protected]
http://www.ironhawker.com
425-828-0738
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00