• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Woomera

1 Database or 2?

6 posts in this topic

i have two program that both use mysql databases.both databases are planned to be hosted on a same server BUT is there any diffrence that i make one mysql DB for both and use prefix name for their tables or make 2 individual DB's?

by diffrence i mean performance diffrence.

0

Share this post


Link to post
Share on other sites

Probably a bit faster to have the two tables.

0

Share this post


Link to post
Share on other sites

tain- do you mean two tables or two databases?

im not exactly sure if you would notice the performance increase tho, unless your working with millions of entries.

i was just thinking about this, seriously like an hour ago, and i just decided to put it all in 1 database. only reason was b/c of organization. say the server where you were going to have the database already has like 20 databases on it... i use phpmyadmin alot, just for testing right now, hopefully i wont ever have to use it later on besides from having to manually edit/delete something for some reason.

0

Share this post


Link to post
Share on other sites

If they're seperate programs containing seperate data it's generally recommended to have them in seperate databases. What if you wanted to move the database for one application to another server, but not move the database for the other application? If you put them in the same database then you'd be stuck pulling the tables apart for a situtation like that. :)

0

Share this post


Link to post
Share on other sites

if your webhosting only gave / lets you have one database

than use the prefix

but if you got more than one database than use a database for each one

so its quicker to backup / restore / to use

0

Share this post


Link to post
Share on other sites

I was going to post about this but considering the original post's date and the lack of a response from the original poster, I'd almost say this is a dead topic.

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.