Re: Unique items from all columns, very slow

[Willie Gnarlson]

On 4/21/05, Willie Gnarlson <willie.gnarlson@stripped> 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