Hello all,
I'm just new to DBI, it's my first working DBI script so please don't laugh too hard
at me. The script below works fine (AFAIK) but is slow - inserting 10 records into
the table takes ~1 hour 20 minutes. I think that's because I placed $sth =
$dbh->prepare in the while loop insi
Many, many thanks for all of you - I'm going to use your expertise right now.
Greg
>>> "Greg Wardawy" <[EMAIL PROTECTED]> 06/15/01 11:33AM >>>
Hello all,
I'm just new to DBI, it's my first working DBI script so please don't laugh too hard
Thanks a lot. It's much better now - inserting 100K records takes just 26 min.
Greg
t; "Sterin, Ilya" <[EMAIL PROTECTED]> 06/15/01 01:40PM >>>
What exactly did you change. Just used placeholders? If yes, we can use
this as an example for anyone else here, since this is a tremendous time
change.
Ilya
-Original Message-
From: Greg Wardawy
To: [EMAIL PROT
depending on the value of the variable.
Hello all,
I'm having problems trying to insert data into different columns depending on the
value of the variable.
Here is the situation:
if the value of $za01 = "QA" I need the value of $sdq[$i+1] to be written into the
curr_invent column but if $za01
ot;) to ($za01 eq 'QS')
or a pattern match, like ($za01 =~ m/QS/). This is more of a PERL issue than DBI
related to
it's use of strings.
Andy
-Original Message-
From: Greg Wardawy [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 3:22 PM
To: [EMAIL PROTECTED]
Subject