Timing your clone app for fetching the jobs table I had these results:
- hh:mm:38.462080
- hh:mm:39.887506
- hh:mm:40.029495
- hh:mm:40.212050
Where:
data_access_client:
print('0) '+str(datetime.datetime.now()))
__joblist = anvil.server.call('get_joblist')
print('3) '+str(datetime.datetime.now()))
and
data_access_server
print('1) '+str(datetime.datetime.now()))
jobs = app_tables.jobhistorymaster.search(tables.order_by("jobDate",ascending=False))
print('2) '+str(datetime.datetime.now()))
What looks strange is the 1.5 sec to have the client to the server (1->2).
Then it’s a 0.2 and a 0.2 to complete.