Finding duplicates

[Ruslan Zasukhin]

On 8/2/08 11:42 AM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Thanks Thorsten,
> 
> with a bit of modification it worked
> 
> select  
> RecID 
> ,user_lastname 
> ,user_firstname 
> ,user_mailaddress,user_logonname,user_password,objptr_modified_by-
>> user_lastname As 'Modified by' from tbl_users where
> concat(user_firstname,'_',user_lastname) in
> (select NAMEIDENTIFIER from
> (select DUPCOUNT, NAMEIDENTIFIER from
> (select count(*) AS DUPCOUNT, concat(user_firstname,'_',user_lastname)
> AS NAMEIDENTIFIER from tbl_users where user_lastname is not null group
> by user_firstname, user_lastname ) where dupcount>1))
> order by user_lastname, user_firstname
> 
> 
> However I could surely do with a bit of explaining as to  why this
> works.
> 
> Maybe interesting for Ruslan: query takes 17 seconds on a table with
> 1000 records (Can't say whether this is good or bad)

You can do in SQL Editor

    SET PROPERTY TuneMode TO TRUE

Then do query 

And check Tunes_XXXXXXXX.log file to see which exactly  part of query have
eat main time. And compare to other parts.

We will think about this COMMON task :)


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]