Re: [PERFORM] Duplicate deletion optimizations

2012-01-07 Thread Marc Eberhard
Hi Pierre! On 7 January 2012 12:20, Pierre C wrote: > I'm stuck home with flu, so I'm happy to help ;) [...] > I'll build an example setup to make it clearer... [...] That's almost identical to my tables. :-) > Note that the "distance" field represents the distance (in time) between the > inter

Re: [PERFORM] Duplicate deletion optimizations

2012-01-06 Thread Marc Eberhard
On 6 January 2012 20:38, Samuel Gendler wrote: > On Fri, Jan 6, 2012 at 12:22 PM, Marc Eberhard > wrote: >> On 6 January 2012 20:02, Samuel Gendler wrote: >> > Have you considered doing the insert by doing a bulk insert into a temp >> > table and then pulling rows

Re: [PERFORM] Duplicate deletion optimizations

2012-01-06 Thread Marc Eberhard
Hi Samuel! On 6 January 2012 20:02, Samuel Gendler wrote: > Have you considered doing the insert by doing a bulk insert into a temp > table and then pulling rows that don't exist across to the final table in > one query and updating rows that do exist in another query?  I did a very > brief scan