Graph Dashlet Loading Times

We’ve got a small problem with a slight delay in dashlet graphs loading. Would you please be able to investigate to see if there’s anything that can be done to decrease the wait time?

first thing to do is checking the query generated against database and see if additional indexes shall be set.
Turn on query analyzer in integrate tab and save.
Click Tools > Query analyzer in report detailview. You will see the query and below it the results of EXPLAIN command that will output information about where clauses and indexes in use