Re^5: Perl Debugger degrades performance when reading large spreadsheet

I was talking about &DB::sub() the function

the debugger will call it for every function call and theoretically it should be possible to temporarily change some flags only for your spreadsheet calls.

see also the flags determining if &DB::DB() is called or not.

Anyway I concur with Corion that minimizing the the actual sheets for debugging is the better approach.

Cheers Rolf
_{(addicted to the Perl Programming Language :)

Wikisyntax for the Monastery}

Comment on Re^5: Perl Debugger degrades performance when reading large spreadsheet

Replies are listed 'Best First'.
Re^6: Perl Debugger degrades performance when reading large spreadsheet by boleary (Scribe) on Aug 31, 2021 at 13:57 UTC
I agree 100%, I often work around this performance issue by doing what Corion suggests. I'll use the real spreadsheet module to read the data, then export it to a json or yml file In the test I'll import the json/yml file instead of reading the spreadsheet. The json/yml import is easily 10x faster than the spreadsheet read even without the debugger I was just hoping there might be a clever way to skip those steps... This was really a one off test I was running so I didn't take the time to do the export.	[reply]

Replies are listed 'Best First'.

Re^6: Perl Debugger degrades performance when reading large spreadsheet
by boleary (Scribe) on Aug 31, 2021 at 13:57 UTC

I agree 100%,
I often work around this performance issue by doing what Corion suggests.
I'll use the real spreadsheet module to read the data, then export it to a json or yml file
In the test I'll import the json/yml file instead of reading the spreadsheet.
The json/yml import is easily 10x faster than the spreadsheet read even without the debugger

I was just hoping there might be a clever way to skip those steps...
This was really a one off test I was running so I didn't take the time to do the export.

[reply]