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: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]