Out of the two methods below, what's the fastest way to server a lot of MySQL data on a Linux Server?
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?
Public Comments
- 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.
Powered by Yahoo! Answers