Re: [PERFORM] Duplicate deletion optimizations

2012-01-07 Thread Marc Eberhard
Hi Pierre! On 7 January 2012 12:20, Pierre C li...@peufeu.com 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

Re: [PERFORM] Duplicate deletion optimizations

2012-01-06 Thread Marc Eberhard
Hi Samuel! On 6 January 2012 20:02, Samuel Gendler sgend...@ideasculptor.com 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

Re: [PERFORM] Duplicate deletion optimizations

2012-01-06 Thread Marc Eberhard
On 6 January 2012 20:38, Samuel Gendler sgend...@ideasculptor.com wrote: On Fri, Jan 6, 2012 at 12:22 PM, Marc Eberhard eberhar...@googlemail.com wrote: On 6 January 2012 20:02, Samuel Gendler sgend...@ideasculptor.com wrote: Have you considered doing the insert by doing a bulk insert