Please help me making the tool more efficient in data fetching and give better interaction in dashboard drill down.

Question

Here below are my configurations.

Database : Postgresql
 

Machine Information : Core i3 with 8GB RAM

Scenario : I have a database which contains sale order table and invoice table of about 10 years(approximately 50000-60000 records each). I tried to visualise the sale progress and some reporting practices with the entire data. Used Join queries with better optimisation also.

I added tables,bar charts,line charts and other selection tools. It take 10-12 sec for each filter/drill down. Also tied the WHAT-IF multi dimensional analysis with the same data and takes 6-8 sec for each drill down.

The appearance satisfied me and wish to use the product. But the performance disappointing me badly. I would be thankful if you can let me know whether it related to my configuration problem or any alternative solution

Comments

How is the data in your database organized? If you use a star schema approach and index the fields that you commonly filter on, your drill downs should fly. Hope this helps.