I'm planing to design a database that contains only 2 tables (stats1 and stats2), but, this tables will contain rows going to 40 000 000 records!

all the records will be "positive/unsigned" integers.

MySQL client version: 5.0.91

Here's some info concerning both tables:

**stats1**

total current records = 10 000 000

contains 3 columns that stores fixed numerals as follow:

- colA = 12345678901
- colB = 1234
- colC = 12345678

**stats2**

total current records = 5 000 000

contains 3 columns that stores fixed numerals as follow:

- colA = 1234567890
- colB = 12345678901234
- colC = 12345678

I know a little bit about MySQL, PHPmyadmin but need your advice concerning making this efficient.

thanx!

ishuge. – MainMa Jul 7 '10 at 15:22