Hi, Dave Page wrote:
Comments below prefixed DP.Yes, I made sure logging was set to none.
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.
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.
Regards,
Didier
--
Didier Moens
-----
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
tel ++32(9)2645309 fax ++32(9)2645348
http://www.dmb.rug.ac.be
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
