We did this at PERC if I'm reading you right. Calculating the trend (and thereby predicting market direction) turned out to be very expensive in terms of processor time. I suggest extensive use of hash tables to take the load of the raw data. Run a scheduled task to recreate lookup tables and show the data from there, that way you get instant loading of the resultset, even tho tha data actually takes a good few minutes to create.
|