Re: [PERFORM] Optimizing Time Series Access

2014-04-09 Thread Robert Burgholzer
Dave, Thanks for asking about the structure. I can say that it appears to me to be fairly moderately structured, and I will list those aspects that I think make it defined (STRUCTURED), and those which are more variable (Moderately...). STRUCTURED: Location - Values are keyed according to a locat

[PERFORM] Optimizing Time Series Access

2014-04-08 Thread Robert Burgholzer
I am looking for advice on dealing with large tables of environmental model data and looking for alternatives to my current optimization approaches. Basically, I have about 1 Billion records stored in a table which I access in groups of roughly 23 Million at a time. Which means that I have somew