Re: Unique items from all columns, very slow

2005-04-21 Thread Willie Gnarlson
On 4/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/21/2005 01:39:15 > PM: > > On 4/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 > > 05:46:25 PM: > > > > On 4/20/05, [EMAIL

Re: Unique items from all columns, very slow

2005-04-21 Thread SGreen
Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/21/2005 01:39:15 PM: > On 4/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 > 05:46:25 PM: > > > On 4/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Willie Gnarlson <[E

Re: Unique items from all columns, very slow

2005-04-21 Thread Willie Gnarlson
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

Re: Unique items from all columns, very slow

2005-04-21 Thread Willie Gnarlson
On 4/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 05:46:25 PM: > > On 4/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 > 01:56:03 PM: > > > > On 4/20/05, Dan Nels

Re: Unique items from all columns, very slow

2005-04-21 Thread SGreen
Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 05:46:25 PM: > On 4/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 01:56:03 PM: > > > On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > > > > In the last episode (Apr 20),

Re: Unique items from all columns, very slow

2005-04-20 Thread Willie Gnarlson
On 4/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 01:56:03 PM: > > On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > > > In the last episode (Apr 20), Willie Gnarlson said: > > > > I have been attempting to uncover a fast method

Re: Unique items from all columns, very slow

2005-04-20 Thread SGreen
Willie Gnarlson <[EMAIL PROTECTED]> wrote on 04/20/2005 01:56:03 PM: > On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > > In the last episode (Apr 20), Willie Gnarlson said: > > > I have been attempting to uncover a fast method for retrieving unique > > > items from every column in a table. T

Re: Unique items from all columns, very slow

2005-04-20 Thread Willie Gnarlson
On 4/20/05, Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Apr 20), Willie Gnarlson said: > > I have been attempting to uncover a fast method for retrieving unique > > items from every column in a table. The table has approximately 60 > > thousand rows. Each row has an index associate

Re: Unique items from all columns, very slow

2005-04-19 Thread Dan Nelson
In the last episode (Apr 20), Willie Gnarlson said: > I have been attempting to uncover a fast method for retrieving unique > items from every column in a table. The table has approximately 60 > thousand rows. Each row has an index associated with it, and running > 'explain select distinct class fr

Unique items from all columns, very slow

2005-04-19 Thread Willie Gnarlson
Hello, I have been attempting to uncover a fast method for retrieving unique items from every column in a table. The table has approximately 60 thousand rows. Each row has an index associated with it, and running 'explain select distinct class from dlist' shows that it is using the index. However