[email]cronokleehotmail.com[/email] wrote:I don't think there's that much performance difference. However, I keep> This is probably a stupid question but is how is there much of a
> difference in performance in storing all tables in the one database and
> spreading the info over a few databases.
> In other words:
> 1 database with 50 tables VS 5 databases with 10 tables each?
unrelated information in different databases for other reasons. For
instance, if I wanted to move my store to another server, I could just
move that database.
Or I can backup databases which change regularly on a daily basis, and
those which change occasionally weekly.
Also, user maintenance is easier when dealing with different databases.
Yes, you can assign privileges at the table level in MySQL - but it's
a lot easier to grant or deny access to one database than 20 tables. A
lot easier to keep track of, also.
Remove the "x" from my email address
JDS Computer Training Corp.