Perl Debugger degrades performance when reading large spreadsheet

boleary has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Perl Debugger degrades performance when reading large spreadsheet by Corion (Patriarch) on Aug 31, 2021 at 12:36 UTC
To stop your program at a "good" place, you can enter the debugger at the interesting place using `$DB::single = 1;` [download] Personally, I would first reduce the data read in from Spreadsheet::Read and/or replace it with static data to speed things up.	[reply] [d/l]
Re^2: Perl Debugger degrades performance when reading large spreadsheet by boleary (Scribe) on Aug 31, 2021 at 16:21 UTC
Corion... Maybe I misunderstand your use of `$DB::single=1` [download] To use that, doesn't the code needs to be loaded with the debugger? So every sub is already wrapped with a DB::sub() like Rolf suggests. and the whole script is already slowed down before I hit the `$DB::single =1;` If I don't load through debugger I get: `Name "DB::single" used only once: possible typo at fix_ahdl_dcfx_const +raint_file.pl line 78.` [download] I can fix that warning by adding `use DB;` [download] But I still can't interact with the debugger without running with the perl -d flag. Now I'm really done spending time on this :) But it has helped me understand the debugger a bit more.	[reply] [d/l] [select]
Re^3: Perl Debugger degrades performance when reading large spreadsheet by karlgoethebier (Abbot) on Aug 31, 2021 at 18:10 UTC
«…I'm really done…» See print for a human solution 🤪 «The Crux of the Biscuit is the Apostrophe»	[reply]
Re: Perl Debugger degrades performance when reading large spreadsheet by LanX (Saint) on Aug 31, 2021 at 11:46 UTC
The debugger is slow, that's a fact! It's using callbacks from `DB::` namespace for each command, so you might be able to write wrappers for Spreadsheet::Read calls and locally replace those callbacks with faster dummies. No idea how much you'll gain. I also remember a YAPC talk from some Booking guys about speeding up the debugger, maybe it helps looking there. see also `perldebug`, `perl5db`, `perldebguts` edit Have also a look at `DB::sub()` Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery}	[reply] [d/l] [select]
Re^2: Perl Debugger degrades performance when reading large spreadsheet by boleary (Scribe) on Aug 31, 2021 at 12:01 UTC
Thanks Rolf! With some further searching I found a module called Enbugger::perl5db It looks like it might be able to turn off/on the debugger Actually it turns on the debugger, but can't be used to turn it off.. But that may be all I need :)	[reply]
Re^3: Perl Debugger degrades performance when reading large spreadsheet by LanX (Saint) on Aug 31, 2021 at 12:06 UTC
There are also various trace modes, I'd go for manipulating DB::sub() to toggle the mode and/or callbacks for Spreadsheet calls. update see also https://perldoc.perl.org/perldebguts#Debugger-Internals Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery}	[reply]
Re^4: Perl Debugger degrades performance when reading large spreadsheet by boleary (Scribe) on Aug 31, 2021 at 13:26 UTC
Re^5: Perl Debugger degrades performance when reading large spreadsheet by LanX (Saint) on Aug 31, 2021 at 13:32 UTC
Some notes below your chosen depth have not been shown here

edit

update