• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Building a new cart, looking for DB advice

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
jglazer63
Asked:
jglazer63
  • 3
  • 3
1 Solution
 
RiteshShahCommented:
are you planning to maintain separate database just for shopping cart? I guess it's not a good idea.
0
 
jglazer63Author Commented:
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
 
RiteshShahCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
jglazer63Author Commented:
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
 
RiteshShahCommented:
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
 
jglazer63Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now