Extremely slow solution import

[Richard1521662995]

Hi,

When I import a solution the time taken to import has increased drastically. It now takes around 35 minutes to import. I have recently updated to 2021.03, not sure if this is relevant or not. Have tried compacting the solution/modules, made no difference to the time taken. Next tried deleting the all the solutions, restarted the server and imported again, made no difference to the time taken. Any ideas why the import is taking such a long time now?

Thanks.

[Andrei Costescu]

The export is created using with the same options as before (when it took less time) right?
Make sure you don't have import hook solutions that suddenly take a long time to execute during the import process.
Also make sure that any DB connections you might have (through the network) are not much slower.

If those are not the causes then you can create a case in our support system and insert in it 3 stack-dumps made from the admin page (let's say at least 1 min apart from each-other, all after the usual import time has passed) to see what it's doing. If that is not enough we might need a sample solution - but I hope that will not be needed.

[Richard1521662995]

Hi,

Same options as before, have created a case.

Thanks

[Richard1521662995]

It looks the problem is related to latest PostgreSQL JDBC driver. Running PostgreSQL v12.7. Reverted back to the JDBC driver i was using and solution imports in 29 seconds instead of 35 minutes.

[Richard1521662995]

Have updated PostgreSQL to v13.3 and with JDBC driver 42.2.22 solution imports nice and quick.

[Andrei Costescu]

I see. Do mention this on the case as well please.
So the driver shipped with 03 was the culprit or another one - not sure what "latest" was referring to - "from Servoy 03" or latest overall? Or a combination of that driver and your PostgreSQL version?

[Richard1521662995]

The latest JDBC driver 4.2.22 and PostgreSQL v12.7 caused the extremely slow solution import. Went back to v42.2.5 of the JDBC driver with PostgreSQL v12.7 and solution import ran quickly. With PostgreSQL v13.3 and the latest JDBC driver 4.2.22 solution import speed is fine.

Not sure if JDBC driver v4.2.5 was shipped with 03.

Richard