Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Building a new cart, looking for DB advice

Posted on 2009-05-08
6
Medium Priority
?
155 Views
Last Modified: 2012-05-06
I have a specialized shopping cart written in .ASP and running on top an access database.  Its also compatible with SQL.  I have numerous clients that use this cart and in each case it's configured to a separate database to store their individual inventories.

I am getting ready to re-write the entire thing in ASP.NET and was wondering what the community throught about having all inventories run on top of a single SQL database or should I stick to the issolated database structure either with a ton of simmilar SQL databases or access files?  I've been thinking about pros and cons for these for a while and need to make a decision.

Any advice?
0
Comment
Question by:jglazer63
  • 3
  • 3
6 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24335854
are you planning to maintain separate database just for shopping cart? I guess it's not a good idea.
0
 

Author Comment

by:jglazer63
ID: 24335874
yes thats how it is now.  Each client runs on two access databases, one for the inventory (which doesn't change all that much) and one for the orders (which changes often and can get quite large).  I am looking at making this more efficient.  From a security standpoint the advantages of separate databases, at least one per client, is obvious.  Also from an integrity point of view (corruption only hurts one client).  I am concerned that if I combine them all together it will get slower and slower as time goes on and the database gets larger and larger.

Still kicking it around in my head...
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24335898
I suggest not to maintain two database rather just create one and to share IO load and boost up performance, use partition and more file groups.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:jglazer63
ID: 24340848
Well the question really was should I create a separate database for each client (as it is now) or try to maintain all clients in one db?  
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 2000 total points
ID: 24341608
You should maintain all client in one DB. but you have to have proper security management policy. because more database means, more work, more maintenance, more security and more backup.
0
 

Author Closing Comment

by:jglazer63
ID: 31579426
Thanks!
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question