Re: Migrating data from MSAccess

On Thursday 21 Nov 2002 9:26 pm, wsheldah@lexmark.com wrote:
> Sounds like you have some on insert triggers that are taking a while to
> validate the data. You probably want to look for ways to speed up the
> triggers, and reduce the amount of validation that has to be done for every
> record if at all possible.

I think Wes is right here, but there are a couple of other things to check:

1. Try updating 1000 rows of a simple dummy table - how long does it take?
2. Same again but wrapped within BEGIN;...COMMIT; so it's one transaction. How
long now?

If both are slow, look to your ODBC. If only the first is slow, try batching
updates into transactions containing somewhere between 100-10,000 rows.

If it turns out PG is slow, we'll need to know more about the database and the
validation etc. you have on it.

--
  Richard Huxton

> "Mihai Gheorghiu" <admin@planwithtan.com>@postgresql.org on 11/21/2002
> 12:45:26 PM
>
> Sent by:    pgsql-general-owner@postgresql.org
>
>
> To:    <pgsql-general@postgresql.org>
> cc:
> Subject:    [GENERAL] Migrating data from MSAccess
>
> I'm at the stage to rehearse data migration from MSAccess to PG. The PG db
> actually consolidates 4 MSAccess dbs, with all the possible data
> validations
> and integrity in place. I have some queries over the Access tables which
> then write the data to the ODBC-linked tables in the PG db.