Very slow reaction from Edit to Browse mode

[Janusz]

I had to use my databse in a place with not fast internet - and finally it looks that the application is very slow and is difficult to use it.
I did some more investigation with following observation.
If you have not bad internet 10Mb/s or faster you wil not notice anything but if the internet is slower than it start to be painfull.

I did some quick check with the following simple table (4 colums, 72 raws, just to keep some text descriptions)

id INT(1); Field_1 varchar(60); Field_2 text; Field_3 text
max real number of characters in field_2 or field_3 is 20000 per raw (but typically much less)

I connected my laptop to internet via my mobile (about 1Mb/s) and rougtly had following results:

Button press from main Fast Form Tab to open table in browse view - 2sec (ok no issue)
Opening one record to Edit mode - less than 1sec. (ok - no issue)
going 1 step back to browse view - 5 sec or more
going back from Edit to the main view/first level - less than 2 sec (ok - no issue)

Looks like there is some delay when switching from Edit to Grid view
(NO specific filters or sorting was applied).
Do you have some experiece or advice how to proceed to have faster reaction when going back from Edit to Browse view?

MariaDB and Debian Stretch, Apache2, PHP 7.3

[Janusz]

Hi,
Additionally to above observation I measured on my Debian server the network speed.
So when I go from Browse to Edit mode there are some data taken from the server to my PC (TX) - what is absolutly normal.
But when I switch from Edit to Browse mode big amount of data is sent out from my PC to the server (RX)
(but there was no data modification to any record).

To reduce data amount transfer from PC to Server I minimised "Raws per page" value to 5 (from default 20).

So generally what I measured (with good network connection)
From Browse to Edit mode the transfer reach: 4 Mb/s (Tx: server->PC)

From Edit to Browse mode the transfer is above: 8 Mb/s (Rx: PC -> server) - do we need to send such amount of data from PC to server if no modification done to any of the records?
https://drive.google.com/file/d/13W70jw ... sp=sharing
(in the link several trials to go Edit-browse-Edit-.....)

This point is extremally important for me because the database will be used in a place with bad internet.

[kev1n]

Hi,

I run a quick test. When a Browse Screen is opened, ca. 200 bytes are transferred in function nuForm(), object last, that is passed to nuAjax()
When going back from Edit to Browse mode, ca. 20000 bytes are transferred.

Also, when I use 2G network mode, it takes about 5-6 secs to go from Edit to Browse.

[Janusz]

So general question - are we able to improve it somehow?

When starting initially Browse screen with button - it goes fast.
The only issue is when going from edit to browse mode. Do we need to send such big amount of data from PC to Server.

[kev1n]

So general question - are we able to improve it somehow?

You could ask nuSoftware Professional Services - info@nusoftware.com