The performance of the cloud database is not impressive compared to local MS Access database evening after making sure that the following are done:
(1) All calculation are done by the server itself
(2) All combo boxes load empty until four matching characters are type in
(3) All reports are powered by views
(4) The only objects binded to linked tables are data entry forms , but make sure they do not load with data we have turn on the data entry property
(5) All reports that require union queries are done directly in the server
(6) We made sure that the access front end does no calculations whatsoever or simply a mirror of what the back end does.
The performance is still not good especially the point of sales , I'm afraid this will create unnecessary ques/long lines, I have also noticed the freezing of forms when saving the data though its temporary but I do not like it. Does it mean that I'm missing something here?????????//
(1) All calculation are done by the server itself
(2) All combo boxes load empty until four matching characters are type in
(3) All reports are powered by views
(4) The only objects binded to linked tables are data entry forms , but make sure they do not load with data we have turn on the data entry property
(5) All reports that require union queries are done directly in the server
(6) We made sure that the access front end does no calculations whatsoever or simply a mirror of what the back end does.
The performance is still not good especially the point of sales , I'm afraid this will create unnecessary ques/long lines, I have also noticed the freezing of forms when saving the data though its temporary but I do not like it. Does it mean that I'm missing something here?????????//