AnsweredAssumed Answered

Dashboard Stats: Very slow loading time

Question asked by openspace on Mar 5, 2015
Latest reply on Mar 5, 2015 by openspace

Alright! I have an extreme "beginners situation." This is my first database let alone coding project, so bare with me. I created a dashboard for my database that compiles information from 3 or 4 tables into one place using SQL. Works great... fantastic... until I imported over a thousand contacts.... now the thing is so slow to load the dashboard I might as well have created a time machine back to 1989. To say the least, it's a total fail.

Screen Shot 2015-03-05 at 12.10.59 AM.png

I have a hunch as to what the problem is... well at least I can identify the elephant in the room which is the fact that I'm guilty of creating a lot of SQL calculations on the dashboard.... a lot (see below). There must be a better way to do this...... ? A way to speed/clean things up?

Screen Shot 2015-03-05 at 12.12.00 AM.png

 

I'll post an earlier version of the file without any confidential information so you can take a look at the mess I've created. I'm pretty sure the calculations on the dashboard are the same as the version I'm working with now. i'm running fm 13.

Attachments

Outcomes