1. Dexter Madrinan
  2. PowerBuilder
  3. Monday, 13 March 2023 07:38 AM UTC

Guys,

Our clients have complained about the application update that takes too long in server. Can someone give some advice in how to resolve this?

 

 - Our External files size is 400mb and configured "Download the app files as Necessary"

 - Runtime is 22.0.0.1892, and most are ticked except Database Interfaces that we enabled only for OLE and SNC,

 - Executable is not signed.

 - App validation is not enabled

 - Update Strategy are Update when connected, Download the app files as Necessary, Show the loading animation before the app runs, Run as Administrator only when the app first starts or updated.

 - PBD size is 400mb

 - Total application size is 810 MB

 

PB Version:  Powerbuilder 2022.

 

Your advice is highly appreciated.

 

Thank you very much.

 

Dexter P Madrinan

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 March 2023 02:22 AM UTC
  2. PowerBuilder
  3. # Permalink
You can try turning that off as well as a test to see if that helps. However based on other posts, it could be the way you've packaged all those external files.
Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 09:29 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

You should give us more details about your powerclient project. Anyway. You say external files are 400 MB. How are they organized? How many external files do you have? Have you tried to use packages? Are you aware that External files are excluded from download as necessary?

Andreas.

Comment
  1. Dexter Madrinan
  2. Monday, 13 March 2023 09:42 AM UTC
External files are excluded from download except for the new files but this issue is nothing to do with that what i feel. Any advice what to do?
  1. Helpful
There are no comments made yet.
Dexter Madrinan Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 09:43 AM UTC
  2. PowerBuilder
  3. # 2

Comment
  1. Andreas Mykonios
  2. Tuesday, 14 March 2023 06:54 AM UTC
A question based on that screenshot. Why do you deploy pdb files with your dll's?

Andreas.
  1. Helpful
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 10:17 AM UTC
  2. PowerBuilder
  3. # 3

As you are using packages, I believe that if one file inside your package is modified, then the whole package will be resent. Packages, as I understand them, have meaning to group files that won't change, or if there is some modification the whole group of files inside a specific package, should be uploaded again. So it's important to organize your external files in more than one packages trying to put in each package files that may be modified together.

From powerbuilder help file:

To deploy files as one compressed package, select Files preloaded as compressed packages from the list box, then click Create Package to create a package, and then click Add Folder or Add Files to add the folder or files under this package.

The key here is: one compressed package. If any file inside the package changes, the whole package will be regenerated (compressed) and will be changed. It will need to be resent, extracted etc.

Andreas.

Comment
  1. Dexter Madrinan
  2. Tuesday, 14 March 2023 02:32 AM UTC
Hi Andreas,



In a compressed package and none of the file was changed but new file is added. Will this package be generated again?
  1. Helpful
  1. Andreas Mykonios
  2. Tuesday, 14 March 2023 06:47 AM UTC
Yes. It should be generated again and as a result resent as an update...
  1. Helpful
There are no comments made yet.
Dexter Madrinan Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 10:24 AM UTC
  2. PowerBuilder
  3. # 4

Hi Andreas,

 

Let me try this and check the updates.

 

Thank you very much.

 

Dexter

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 13:43 PM UTC
  2. PowerBuilder
  3. # 5

Hi Dexter;

   Are your PBD's being encrypted?

Regards ... Chris 

Comment
  1. Dexter Madrinan
  2. Tuesday, 14 March 2023 02:27 AM UTC
Hi Chris,



Yes
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 13 March 2023 16:28 PM UTC
  2. PowerBuilder
  3. # 6

How long is it taking?

What kind of network connection is between the client computer and your Web server?

What types of external files are very large ones contributing most to the 400MB?  If most of the 400MB is because of your external DLLs, DLLs cannot be compressed anyway so I think you may boost performance by putting your external DLLs under the "Uncompressed" section instead of packages.

Comment
  1. Dexter Madrinan
  2. Tuesday, 14 March 2023 02:42 AM UTC
It is LAN connection and powerclient is up on IIS.



Now, I reorganized my packages into 5 to segregate the most changed packages. I may moved my DLLS to "Uncompressed" if this wont improved the download.



Thank you Armeen.







  1. Helpful
  1. Armeen Mazda @Appeon
  2. Tuesday, 14 March 2023 16:20 PM UTC
You're welcome. Also, if you have a lot of media files (images, videos, etc.) those also cannot be compressed. There is special option to dynamically load the media files instead of pre-loading it at startup which makes startup of app slower. So I would suggest put all media files under the "Dynamically load images" section.
  1. Helpful 2
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.