Hello Shekar,
This is a very tough question to answer without knowing your model so I would recommend you higher an expert that can help you out.
However, here are a few things you should take into account:
1) Do you really need all the columns? Make sure you only pull what you use.
2) Can you split your application into different ones? you can use document chaining to connect one app to the other. In the first you can show top level data and in your second app you can should the details.
3) You might need to think about incrementing the RAM in your server. this is not always the right solution, but again, this depends on your current environment.
4) Are you joining tables using long keys? If so, replace these using the autonumber function. This will make the key size smaller.
5) How many user are accessing the app at the same time? The more users, the more RAM you'll need.
6) Try aggregating data before you present it. You don't usually need all the details.
Again, improving the performance of an app is really complex and you might need expert help.
I hope this helps.
JV
.png "Luminary Alumni"){kind=icon}
