Very slow reaction from Edit to Browse mode

Questions related to using nuBuilder Forte.

Very slow reaction from Edit to Browse mode

Postby Janusz » Thu Jan 03, 2019 8:45 am

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
 
Posts: 229
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Very slow reaction from Edit to Browse mode

Postby Janusz » Thu Jan 03, 2019 8:09 pm

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.
Janusz
 
Posts: 229
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Very slow reaction from Edit to Browse mode

Postby kev1n » Thu Jan 03, 2019 9:10 pm

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.
kev1n
 
Posts: 266
Joined: Mon Oct 15, 2018 2:13 am

Re: Very slow reaction from Edit to Browse mode

Postby Janusz » Thu Jan 03, 2019 9:42 pm

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.
Janusz
 
Posts: 229
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Very slow reaction from Edit to Browse mode

Postby kev1n » Thu Jan 03, 2019 10:06 pm

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

You could ask nuSoftware Professional Services - info@nusoftware.com
kev1n
 
Posts: 266
Joined: Mon Oct 15, 2018 2:13 am


Return to General



cron