List:General Discussion« Previous MessageNext Message »
From:Willie Gnarlson Date:April 21 2005 5:50pm
Subject:Re: Unique items from all columns, very slow
View as plain text  
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
Thread
Unique items from all columns, very slowWillie Gnarlson20 Apr
  • Re: Unique items from all columns, very slowDan Nelson20 Apr
    • Re: Unique items from all columns, very slowWillie Gnarlson20 Apr
      • Re: Unique items from all columns, very slowSGreen20 Apr
        • Re: Unique items from all columns, very slowWillie Gnarlson20 Apr
          • Re: Unique items from all columns, very slowSGreen21 Apr
            • Re: Unique items from all columns, very slowWillie Gnarlson21 Apr
              • Re: Unique items from all columns, very slowWillie Gnarlson21 Apr
              • Re: Unique items from all columns, very slowSGreen21 Apr
                • Re: Unique items from all columns, very slowWillie Gnarlson21 Apr