Extremely slow solution import

Questions and answers for all installation-related topics for Servoy products

Extremely slow solution import

Postby Richard1521662995 » Fri Jun 25, 2021 4:54 pm

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.
Richard Clarke
acss.co.uk
Richard1521662995
 
Posts: 25
Joined: Wed Mar 21, 2018 10:09 pm

Re: Extremely slow solution import

Postby Andrei Costescu » Tue Jun 29, 2021 10:42 am

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.
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 1011
Joined: Tue Jun 26, 2007 3:14 pm

Re: Extremely slow solution import

Postby Richard1521662995 » Wed Jun 30, 2021 10:45 am

Hi,

Same options as before, have created a case.

Thanks
Richard Clarke
acss.co.uk
Richard1521662995
 
Posts: 25
Joined: Wed Mar 21, 2018 10:09 pm

Re: Extremely slow solution import

Postby Richard1521662995 » Mon Jul 05, 2021 5:05 pm

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
Richard Clarke
acss.co.uk
Richard1521662995
 
Posts: 25
Joined: Wed Mar 21, 2018 10:09 pm

Re: Extremely slow solution import

Postby Richard1521662995 » Mon Jul 05, 2021 6:05 pm

Have updated PostgreSQL to v13.3 and with JDBC driver 42.2.22 solution imports nice and quick.
Richard Clarke
acss.co.uk
Richard1521662995
 
Posts: 25
Joined: Wed Mar 21, 2018 10:09 pm

Re: Extremely slow solution import

Postby Andrei Costescu » Mon Jul 05, 2021 7:47 pm

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?
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 1011
Joined: Tue Jun 26, 2007 3:14 pm

Re: Extremely slow solution import

Postby Richard1521662995 » Tue Jul 06, 2021 12:51 pm

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
Richard Clarke
acss.co.uk
Richard1521662995
 
Posts: 25
Joined: Wed Mar 21, 2018 10:09 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 2 guests