More efficient ways to make graphs?
I know this is probably a stupid question, but how can I make graphs more efficient? Right now my database has over 11,000 records for items sold and the management are going to want graphs made soon to see how everything is going. The issue is to have the system generate any graph it is going to take forever. I was curious if there was a way to get the total sold for each item at the end of the month and then put it in a field and use that for the graph? Has anyone tried that?
Thanks for any suggestions!