Forum Discussion
Improve performance Access frontend with Azure backend
> however the form is not updateable any more.
That is probably because you used a PT query. They are never updatable. Rather you would select 1 row from the linked table or a query based on a linked table.
> however the form is not updateable any more.
That is probably because you used a PT query. They are never updatable. Rather you would select 1 row from the linked table or a query based on a linked table.
- That did it thank you. But I've got another question, rather than the modifications I mentioned, do you have some more recommendations I could do to improve performance?
> the performance often leaves something to be desired
> customer will not be happy if the entire application has to be rebuilt all over againIt appears you're going about it the wrong way: it seems YOU decided performance was not adequate, and you THINK customer will not be happy.
That is for them to decide. Presumably they decided on Azure hosting, and they have to understand that comes with consequences. They will have to decide how much time and money they want to invest in making it faster, and what parts of the app should be focused on.
If you search online you should find plenty of discussion of this topic.
One technique I can recommend is local caching of quasi-static tables such as Statuses, States table, and others.- Thank you for your help Tom, data caching is definitely something I will dive into.
