Building a new cart, looking for DB advice

Posted on 2009-05-08
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?
Question by:jglazer63
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 31

Expert Comment

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

Author Comment

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...
LVL 31

Expert Comment

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.
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.


Author Comment

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?  
LVL 31

Accepted Solution

RiteshShah earned 500 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.

Author Closing Comment

ID: 31579426

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

724 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