Your Server

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

  1. 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