PowerTime singularity

Phew, PowerTime is now munching 16 million readings of European precipitation data at last. The images were generated using the PowerShell integration. The graphs consist of rolling 365 day averages. The test run takes 1,365.78 seconds (around about 22 minutes.) Whilst that’s not going to break any speed records, it isn’t as slow as I feared given that no speed optimization has yet been done. The test gives an excellent basis for improving performance.

The ECAD test involves reading a file with an index of all of the 1,000 or so weather stations. Then there are 1,000 or so CSV files in which the precipitation data for each weather station is present. Each file needs to be parsed in turn and the data pushed into the database.

The file created is around 1.92 MB in size.

Popularity: 25% [?]

This entry was posted on Thursday, May 22nd, 2008 @ 1:14 pm on the category PowerTime. You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback from your own site.