1. Ivan Vidmar
  2. PowerBuilder
  3. Monday, 4 July 2022 07:59 AM UTC

Our software developer is using your PowerBuilder development software for development of our ERP system. We have a problem in our ERP system when transferring larger files into the database. On the picture below you can see 34.000 sql statement executions when transferring a file of 100 MB. Because of so many sql executions the file transfer to the database takes about 2 minutes. This is almost not acceptable, such transfer should happen in less than 10 seconds.

Our developer says slow transfers are due to the technology available in the PowerBuilder environment. Is this the only technology available for transferring files or do you have some faster alternatives in PowerBuilder?
The database is SAP SQL Anywhere.

Thank you for your answer.