Should I use Multiple databases for images, videos and data?

Question

1.00/5 (1 vote)

See more:

Hi,

I am developing a big project where we will have Three panels i.e. (1) Panel for Registered Users of the website (2) Panel for Registered clients of the website and (3)Admin Panel.

Apart from the panels we have a bulky potential client's database,thousands of images and videos which are to be maintained through out. So my question is that should I use a separate DB for each panel and inter connect them for the whole website or just one DB for everything?

Or Should I use DB1 for images DB2 for streaming videos and DB3 for client's data and so on. The reason for doing this is that I think that way I can manage data, images and videos in a different DBs respectively and which will keep DB size under control which is limited to 250 MB for each database in my case. Second alternative, should I use a distributed database system.

plz. suggest.

Posted 1-Jan-13 22:06pm

winners6

Updated 27-Jan-13 20:37pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar Sultan · Answer 1 · 2013-01-01T22:12:00

Solution 1

First, do you want to say that you want to secure only client's images and videos? You are not concerned about any other things? Second, if you are applying security measures for only selected items, why not to keep other data in the secured boundary as well? It will not cause any harm. Third, distributing data over several databases and then querying multiple databases for a single user from different sources will obviously cost you performance. Rest is your wish.

Posted 1-Jan-13 22:12pm

Zafar Sultan

Comments

winners6 2-Jan-13 4:31am

Zafar, My only concern is that I have been allowed 5 DBs of 100 MB each by the hosting company here and on the other hand, I can not use a single DB as it is of just 100 MB Database which will not suffice in any case. Though purchasing a bigger DB could be a solution. But my simple point was, would it be better to create multiple DBs for a project or creating just one DB for entire project?

Zafar Sultan 2-Jan-13 4:37am

Now that you have made things clearer, I would suggest you to ask your boss to purchase a single DB. Believe me nowadays they come at really affordable prices. I too have unlimited DB's plan for my client. Now if you are able to make it to 1 it is easy to manage and update as per the programmer's percpective. If you have no option but to be stuck with what you have, then please go ahead and create a distributed database solution.