Dave Page wrote:
>Comments below prefixed DP.
>1. Access2K database migration with 1.4.12 is approx. 6 to 8 times
>slower than previous versions (20 minutes -> over two hours), mainly in
>the Foreign Key creation, it seems. I'll check if this is due to pgAdmin
>(1.4.0 -> 1.4.12) or PostgreSQL (7.2.x -> 7.3).
>DP: Check you have logging set to none or errors only. The code has had few changes.
Yes, I made sure logging was set to none.
I ran my tests again, connecting to a PostgreSQL 7.2.2 server (as to
rule out any luring problems with 7.3) :
When migrating my standard Access2K app (about 20 tables, some 100K
records in total, nothing fancy),
- pgAdminII 1.4.12 took approx. 35 minutes to migrate the tables and
create the indexes, before starting to create the foreign keys. After
another 40 minutes, I stopped the app (as I already knew total execution
time would be more than 2 hours) ;
- pgAdminII 1.4.0 took approx. 19 minutes for tables and indexes, and
another 2 minutes for the foreign keys, totalling 21 minutes.
I could test 1.4.1 and 1.4.2, if you'd like.
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
tel ++32(9)2645309 fax ++32(9)2645348
In response to
pgadmin-support by date
|Next:||From: Ana Claudia||Date: 2002-12-27 12:10:18|
|Subject: FW: Bug on version 7.1.1- Duplicated Rows with same primary key|
|Previous:||From: Andres Olarte||Date: 2002-12-26 16:34:36|
|Subject: Problem with tables that have more than 1 field a pkey|