Faster Median Generation

This might or might not matter to anyone, but the price median static export files should be generating faster now.  A combination of consolidating some scripts and queries as well as adding daily pruning of the raw price table should hopefully cut down the generation time from 2 hours to 1 hour or less for all files.  I may need to tweak some of the indexes yet, but hopefully this should reduce some of the stress on my server when I generate these files.

As a general note, the order of the file generation is by RegionID and then the final galaxy-wide file.

Leave a Reply