Re^2: How to optimise " csv into mysql " using TEXT:CSV

Tried Devel::Profile, but its somehow not running and giving the error

String found where operator expected at (eval 8)[C:/Strawberry/perl/si
+te/lib/Devel/Profile.pm:133] line 2, near "croak 'usage: $io->getline
+()'" 
(Do you need to predeclare croak?)
<br>syntax error at (eval 8)[C:/Strawberry/perl/site/lib/Devel/Profile
+.pm:133] line 2, near "croak 'usage: $io->getline()'"
[download]

Comment on Re^2: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql Download Code

Replies are listed 'Best First'.
Re^3: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by GrandFather (Saint) on Aug 06, 2015 at 09:53 UTC
Sorry, it's a while since I profiled code. I suspect in fact that I used Devel::NYTProf (but forgot the module name) rather than Devel::Profile. I've just installed and run NYTProf against a test script and it all worked as advertised. Premature optimization is the root of all job security	[reply]
Re^4: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by taiko (Sexton) on Aug 06, 2015 at 10:31 UTC
Used the Devel:NYTProf module, but need to find out how to read the output, becasue its fr more complex then Devel:ProfileBut it looks very very usefull, thank you	[reply]
Re^5: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by choroba (Cardinal) on Aug 06, 2015 at 11:00 UTC
After running `perl -d:NYTProf script.pl` [download] just run the `nytprofhtml` utility and view the resulting `nytprof/index.html` in your favourite browser. لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ	[reply] [d/l] [select]
Re^6: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by taiko (Sexton) on Aug 06, 2015 at 11:07 UTC
Re^3: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by Laurent_R (Canon) on Aug 06, 2015 at 09:39 UTC
`croak` is a function exported by the Carp module. Try to add this to your code: `use Carp;` [download]	[reply] [d/l] [select]
Re^4: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by taiko (Sexton) on Aug 06, 2015 at 09:50 UTC
nope it didn't help	[reply]
Re^5: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by Laurent_R (Canon) on Aug 06, 2015 at 09:58 UTC
Did you put the: `use Carp;` [download] line before the: `use Devel::Profile;` [download] line? If this still does not work, then please show how you're using the Devel::Profile module.	[reply] [d/l] [select]
Re^4: How to optimise " csv into mysql " using TEXT:CSV_XS and DBD::Mysql by taiko (Sexton) on Aug 06, 2015 at 10:06 UTC
I had Carp after Devel in my code; changed it, but still getting the same error	[reply]