[RPG]uploading performance

[MegumiSawada]

Hi,

Our customer has reported that it takes about 30 seconds to upload 200 records from local database table to the server database.
They would like to upload 5000 records in about 10 seconds.
Is there any way to improve the uploading performance?

They currently use the usual uploading method(like EXAM0302).
They would like to upload all the records in local database table regardless the status. So they use "Write" RPG command instead of "Update" command.

I appreciate your kind advice.

Best Regards,
Megumi Sawada

[MarcusLancaster]

Hi.

Just some initial thoughts...

Does the upload contain any photos/binary data? If so, can the physical dimensions of the images be reduced?

Is any of the textual data already on the server, and will never be changed on the client device, and could therefore be eliminated from the upload?

Cheers.

Marcus.

[MegumiSawada]

Hi Marcus,

Thank you for the comment!

No, it doesn't contain any images. It contains only text data.
They would like to write all the data as new data, so I think they can eliminate any data from uploading...

Best Regards,
Megumi

[MegumiSawada]

Hi,

Can we improve uploading performance some way?
Something like using direct SQL statement for downloading?

Best Regards,
Megumi

[tsupartono]

Hi Megumi,
It took me just under 5 seconds to upload 200 records, so 30 seconds for you was awfully slow.
Can you enable client logging (leave verbose off), run the upload, and send the log file to me.

However, I can confidently say that it's not possible to upload 5000 records in under 10 seconds. I think the more realistic figure would be 25 - 30 seconds.

[tsupartono]

This has been identified as an issue on LongRange for Windows only.
A fix has been produced and a new version is available for download from the Windows Store.