Re: DBD::CSV much slower on osX ?

2005-02-16 Thread charles-perl
On Thu, Feb 03, 2005 at 10:18:43AM +, 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

Re: DBD::CSV much slower on osX ?

2005-02-16 Thread Charles Plessy
On Thu, Feb 03, 2005 at 11:33:10AM -0800, Henri Asseily wrote : 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. Would that mean that running the script

Re: DBD::CSV much slower on osX ?

2005-02-16 Thread Peter J. Holzer
On 2005-02-16 19:44:49 +0900, [EMAIL PROTECTED] wrote: On Thu, Feb 03, 2005 at 10:18:43AM +, 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

Re: Re: DBD::CSV much slower on osX ?

2005-02-16 Thread amonotod
From: Charles Plessy [EMAIL PROTECTED] Date: 2005/02/16 Wed AM 04:58:36 CST Would that mean that running the script twice should dramatically accelerate the execution because the file would then be cached in memory? (which does not work, I just tried). Keep in mind that it's not just

export to

2005-02-16 Thread Stephane Legault
Hi, I'am using DBI::DB2 for a lot of program and now I need to create a programme to archive data. So, I would like to export data from database to a file and then load that file in another db2 database. Here is what I try: $dbh-do(q{export to test.ixf of ixf select * from steph_test}) or die

Re: DBD::CSV much slower on osX ?

2005-02-16 Thread Henri Asseily
On Feb 16, 2005, at 2:58 AM, Charles Plessy wrote: On Thu, Feb 03, 2005 at 11:33:10AM -0800, Henri Asseily wrote : 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.

Re: DBD::CSV much slower on osX ?

2005-02-16 Thread Jeff Zucker
[EMAIL PROTECTED] wrote: Total Elapsed Time = 63.19465 Seconds User+System Time = 43.46465 Seconds Exclusive Times %Time ExclSec CumulS #Calls sec/call Csec/c Name 66.5 28.91 36.463 109445 0.0003 0.0003 SQL::Statement::eval_where I'm the maintainer of DBD::CSV and while I don't have time

Re: DBD::CSV much slower on osX ?

2005-02-16 Thread Tim Bunce
On Wed, Feb 16, 2005 at 07:44:49PM +0900, [EMAIL PROTECTED] wrote: As somebody kindly pointed me out that hardware differences could have a strong impact on the results, I will suppose that this is the reason why I have seen such speed inconsistencies, unless somebody found something

Re: export to

2005-02-16 Thread Jonathan Leffler
I'm not a DB2 expert, but the analogous facility in Informix is UNLOAD and that is emulated in the client (command line) program. That is, IDS (Informix Dynamic Server) does not recognize UNLOAD as a statement but DB-Access (CLP analogue) pretends that it does. Similar problems affect other