Hi Stefan,
I haven't ad experience with such a big table yet, but I would like to make a
guess.
Depending how you use the data (often read, often write, mixed etc.) I would
suggest setting up 2 tables.
If you use innodb you can distribute the two tables over several disks which
should at lea
I am deciding how to setup my MySQL database but i'm having some doubts.
I just want to know which is faster, when I query:
One table with a double primary key and one search field (3 search conditions)
of
Two tables with each a single primary and one search field in each table (3
search conditi
