Hi Ashutos,
ashutoslenka426 wrote:I am showing a form . It is a detail view . There are few calculations using aggregation . This is a Smart client Application in Servoy 7.2 and Postgres 9.2 . The page is loading slowly . The calculations are unstored . Will stored calculation improve the loading of the form ? . What I can do in case of aggregation ? .
You need to provide a little more information to be able to give you any answer. You say the form loads slow (how slow?). Is it always slow or only the first time you show the form?
Do you see slow queries in the performance page on the server or are these all fast (i.e. a few milliseconds).
Also how many fields do you have on your form and how much and what type of data do you show (large text/images/etc) ?
You say you have calculations and aggregates? What are the calculations doing? Can you show some code that you think is slowing things down? And what aggregates (and how many) are you using on the table(s) you are showing on the form?
Also do you show any related data or is it just the one table that is in the context of the form.