I got an application with 160 views, and each view has 70 columns with Click on Sort option enable. View index takes 95% of the database size. Due to large size of database (~ 30 – 35 GB), application has very slow performance. Is there any way to increase application performance without removing Click on Sort option.
Subject: Performance Tuning of Database with 160 views, each with 70 columns
Amit,
Obviously you can improve performance by dramatically reducing the number of views/columns/click-sorts. So you need to look at those options.
If those are not feasible for you then you need to figure out how to best tweak the server to allocate as many resources to view indexing as possible.
regards,
raphael
Subject: Performance Tuning of Database with 160 views, each with 70 columns
StopRethink your approach to design.
Go to http://interfacematter.com
Why do your users need a gazillion views and columns? I’ll bet if you spend some time with them, you’ll find that they really don’t need all of that stuff. The views probably exist to make it easy for users to find a small subset of docs they want to review or process. Find ways to give them a clean GUI that lets them say ‘this set’ and then present them with what they want.
The Interface matters site is awesome and should really get you thinking about how you approach design.
Doug