February 16, 2009

Out of the two methods below, what’s the fastest way to server a lot of MySQL data on a Linux Server?

mysql
Brooke asked:


What’s easier on a server? What requires less CPU and/or RAM?

Method 1. Having sixty 10 MB MySQL databases with 1 table each?

Method 2. Having one 600 MB MySQL database with sixty 10 MB tables?

Tags: , ,

Filed under Programming & Design by administrator

Permalink Print

Comments on Out of the two methods below, what’s the fastest way to server a lot of MySQL data on a Linux Server?

February 17, 2009

AdviceDoctor @ 2:39 pm

One database always. You don’t want to join and associate data across several databases - you do it across several tables in a single database.

600MB really isn’t that large a database, MySQL can handle much larger.