Page 1 of 1

Extremely slow solution import

PostPosted: Fri Jun 25, 2021 4:54 pm
by 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.

Re: Extremely slow solution import

PostPosted: Tue Jun 29, 2021 10:42 am
by 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.

Re: Extremely slow solution import

PostPosted: Wed Jun 30, 2021 10:45 am
by Richard1521662995
Hi,

Same options as before, have created a case.

Thanks

Re: Extremely slow solution import

PostPosted: Mon Jul 05, 2021 5:05 pm
by 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. :D

Re: Extremely slow solution import

PostPosted: Mon Jul 05, 2021 6:05 pm
by Richard1521662995
Have updated PostgreSQL to v13.3 and with JDBC driver 42.2.22 solution imports nice and quick.

Re: Extremely slow solution import

PostPosted: Mon Jul 05, 2021 7:47 pm
by 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?

Re: Extremely slow solution import

PostPosted: Tue Jul 06, 2021 12:51 pm
by 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