Welcome Guest, Not a member yet? Register   Sign In
MySQL use on GoDaddy.com...
#1

[eluser]Harvard725[/eluser]
Hello CodeIgniters,

This is a general application dev question.

On GoDaddy.com I am allowed to use up to 25 MySQL databases. I am expecting 10,000 users registered on my web site within one year. The question is:

Should I utilize numerous databases for unrelated data or just use one database for the whole thing?

I'm looking to avoid more than 200 simultaneous connections to the db.

Perhaps a user's personal data lives in one db while their order info is stored in another. Does this make sense? Am I making this harder than necessary if I do this?

Thank you.
#2

[eluser]TheFuzzy0ne[/eluser]
I think that in your case, it would probably be best to keep all your eggs in one basket. I see no benefit to using more than one database, unless of course they are actually on different servers.

Essentially, what you're asking is similar to asking if it's easier to peddle a tandem on the back seat or the front. Of course, they are both the same.
#3

[eluser]Harvard725[/eluser]
Thank you for the quick response... That makes sense.




Theme © iAndrew 2016 - Forum software by © MyBB