Re: very slow after a while...

On Wed, 2005-04-06 at 18:18 +0300, Costin Manda wrote:

> The script does the following thing:
> 1. read the count of rows in two tables from the mssql database
> 2. read the count of rows of the 'mirror' tables in postgres
> these are tables that get updated rarely and have a maximum of 100000
> records together
> 3. if the counts differ, delete from the mirror table everything and
> reinsert everything.
> 4. THEN do the inserts that get updated on error

if you empty the table in step 3, why do you have to test for
the duplicate id error? are there duplicates in the mssql table?

gnari