On 4/21/05, Willie Gnarlson <[EMAIL PROTECTED]> wrote: (...)
> It actually seems slower. The separate tables from a previous try look > like this: > > CREATE TABLE `ET` ( > `ET` double NOT NULL default '0', > PRIMARY KEY (`ET`), > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > That table has 4781 records, but some have more (one has ~18 > thousand). There are 42 "column" tables. > > Querying all of them took 5.58 seconds. I forgot to mention that those tables *do* have unique items, too. -- Willie Gnarlson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]