Closed JamesMatchett closed 6 years ago
Okay it appears to work in testing, will make final testing documentation tonight with times for the optimised vs un-optimised methods for different size of images and see if it's worthwhile moving across or potentially choosing between each method depending on the size of the image.
Preliminary testing shows that for smaller resolution images the linear-non-parallel method has a smaller time whereas for larger resolution images the parallel method is clearly better. I think the parallel method has a slight overhead in initialisation before it executes but this will all become apparent in testing tonight/near future.
This updated method incorporates the Parllel.For Method to allow each thread to handle 1 row of the generation of the spreadsheet reducing the overall time taken to generate the spreadsheet.
Method is untested and undoubtedly thread safe operations will need to be added and tested.