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 least reduce the access speed to the disks.
However I am not sure if you use unique Indexes which could be a concern in
order to make should each ID refers to only a single record.
I was also thinking about merged tables, but I am believe that they have to be
in a single database in order to work.
Best regards
Nils Valentin
2003年 7月 4日 金曜日 04:49、Stefan Vunckx さんは書きました:
> 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 conditions)
>
>
> I dont find much information about this, and I dont have the time to
> produce a table with 10.000+ records to test this myself.
>
>
> Stefan Vunckx
--
---
Valentin Nils
Internet Technology
E-Mail: nils@stripped
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
