Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?

On Fri, 13 Feb 2004 16:21:29 +0100, I wrote:
>Populate this table with
>    INSERT INTO idmap
>    SELECT id, id, true
>      FROM t;

This should be
    INSERT INTO idmap
    SELECT DISTINCT id, id, true
      FROM t;

Servus
 Manfred