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.
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?
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.