On Feb 3, 2005, at 2:18 AM, Tim Bunce wrote:
On Thu, Feb 03, 2005 at 06:27:05PM +0900, [EMAIL PROTECTED] wrote:Dear list,
I wrote a simple CGI script using DBD::CSV on a linux computer, and then installed it on a iMac G5. Its execution time is now alomst 10 times slower. Using print instructions, I traced the bottleneck to the following instruction :
$sth->execute;
Now I am a bit stuck, as I do not know how to investigate in the DBD::CSV module to find where is the slow isnstruction.
The Devel::DProf module (and/or other code profiling modules) may help.
A couple of quick guesses: - perl config differences - eg configured for threads or not - perhaps on OS X you're using unicode data
Tim.
We need to know a little more about your config: OS X version? What Perl version? I know that Perl by default is threaded on OS X. What type of linux box are you benchmarking against?
Also note that DBD::CSV is significantly impacted by I/O speed. If your IMac G5 has a 4200 rpm drive and your linux box has a 10k rpm one, that makes quite a large difference.
Send me off-list the code and data and I'll test it.
