Speeding up finding duplicates

[Beatrix Willius]

Much too slow. When combined with the base SQL query this is much too slow. I think that I need to optimize this base SQL first.

On 27.04.2011, at 15:45, Ruslan Zasukhin wrote:

> SELECT CheckSum, COUNT(CheckSum) as 'c'
> FROM Mail
> GROUP BY CheckSum
> HAVING c >= 2  

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: archive, clean and search email
http://www.beatrixwillius.de
Fractals, 3d landscapes etc.