search

vallettea / koala

Transpose your Excel calculations into python for better performances and scaling.
GNU General Public License v3.0
143 stars 60 forks source link

Performance testing and benchmark #250

Open bradbase opened 4 years ago

bradbase commented 4 years ago

Does anyone have some guidance or assistance on performance testing Koala or similar?

I can try and make up a spreadsheet that exercises Koala but it would be great to hear about any complex spreadsheets which could be used for performance testing in the open domain so we can potentially get a benchmark off the ground.

I also suspect there are may be sets of operations that others have found to be more challenging than others.

bradbase commented 4 years ago

@brianmay You've been good at performance tuning of Koala, have you got an example spreadsheet which can be shared or a specific set of operations which you have been using Koala to increase performance?

brianmay commented 4 years ago

Unfortunately this is not something I can help with. I work for a consultancy company, that works on proprietary code for clients, and I am now working on another project. :-(

bradbase commented 4 years ago

@brianmay Thanks anyway.

bradbase commented 4 years ago

I have started a repo for performance testing Python Excel calculators.

Currently compares PyCel, Koala2 and my xlcalculator.

https://github.com/bradbase/Perfomance_testing_Python_Excel_calculators