Why does it take so long for charts & graphs to render after reload

[#1]

I am running a script that returns about 10 tables and a total of about 4 million rows.  After the script runs it is taking 20+ minutes for the charts and graphs to render.  I can't even click on the little red "X"s to stop each chart's refresh.

Is it because of the formulas used in the chart? (not very complex).  Is it a CPU or RAM issue?  Any ideas as to what might cause this and how to resolve?

Thanks!    Dan

[Gysbert_Wassenaar]

That could be a ram issue. If your system runs out of real ram it will use a page file which is on the harddisk. That's thousands of times slower than ram. It's also possible you have expressions in your charts that are very costly to compute and require lots of ram and/or cpu time. Or you have chart objects that try to show all 4 million rows instead of an aggregated summary. Or your data model is not optimal and the 10 tables in your data model cause the calculation of cartesian products in your charts. Take a good look at your data model and make sure all the tables are associated to each other correctly. And read this blog post: Recipe for a Memory Statistics analysis