In future releases, it preloads info without that statement. It shouldn't take that long. I am not sure where it puts it. SQL has cache. Basically, when you pull up a chart, the data has to come from your server hard drive from amazingcharts.mdb. This obviously takes longer than if it were already preloaded in your RAM, but I don't know how it would know what to bring up.
When you do pull info on specific things, that is a query and is saved as a page in SQLs memory or cache. That is what the 1GB of memory is for and why you see it take more and more memory UP TO that limit. When you reboot the server all that memory is released back to the server BUT at the cost of losing those pages. If you were to open a random chart, it would take a certain amount of time. The next time you open it, it would theoretically take less. But, given the fact that the amount of data you are pulling up is very small.
I am still not sure where the data is being pulled to when it starts up.
One thing I have forgotten to ask:
ARE YOU SHUTTING DOWN AMAZING CHARTS ON EVERY COMPUTER AT THE END OF THE DAY?
Is so, don't.
