RE: Faster Inserting Code

2004-09-25 Thread Reidy, Ron
ect:RE: Faster Inserting Code On Wed, 2004-09-22 at 15:35, Reidy, Ron wrote: > Well, since you're using Oracle, modify your do() and prepare() statements as > follows: > > $dbh->do("sql statement", {ora_check_sql => 0}) ... > > $dbh->prepare("sql state

RE: Faster Inserting Code

2004-09-24 Thread Jared Still
On Wed, 2004-09-22 at 15:19, Lamb Joseph wrote: > I bagged SQLite and used an Oracle DB. > You may want to check out 'execute_for_fetch', though I confess I have not compared exe times, it may be worth investigating. Jared

RE: Faster Inserting Code

2004-09-24 Thread Jared Still
On Wed, 2004-09-22 at 15:35, Reidy, Ron wrote: > Well, since you're using Oracle, modify your do() and prepare() statements as > follows: > > $dbh->do("sql statement", {ora_check_sql => 0}) ... > > $dbh->prepare("sql statement", {ora_check_sql => 0}) ... > > And you will make your DBA happy. >

Re: Faster Inserting Code

2004-09-24 Thread Eric Bohlman
[EMAIL PROTECTED] (Lamb Joseph) wrote in news:[EMAIL PROTECTED]: > I would like to know how to insert faster using > SQLite. SQLite insertions can be quite slow (doing several disk writes per insert) if AutoCommit is enabled, as it is by default. > my $dbh = DBI->connect("dbi:SQLite:data.dbl")

Re: Faster Inserting Code

2004-09-23 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Lamb Joseph <[EMAIL PROTECTED]> writes: > I would like to know how to insert faster using > SQLite. INSERTing single rows will be slow, regardless of the used DBMS. Export your data and use the SQLite COPY command to import them.

RE: Faster Inserting Code

2004-09-22 Thread Reidy, Ron
n Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Lamb Joseph [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 4:20 PM To: [EMAIL PROTECTED] Subject: RE: Faster Inserting Code I bagged SQLite and used an Oracle DB. Thanks for the help. --- Jeff Urlwin <[EMAI

RE: Faster Inserting Code

2004-09-22 Thread Lamb Joseph
ay, September 22, 2004 4:19 PM > > To: [EMAIL PROTECTED] > > Subject: RE: Faster Inserting Code > > > > > > The select statement gets 30,000+ records. After > 10 > > minutes of inserting using the code below it had > > processed 7000 records. I wo

RE: Faster Inserting Code

2004-09-22 Thread Jeff Urlwin
, too... Jeff > -Original Message- > From: Lamb Joseph [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 22, 2004 4:19 PM > To: [EMAIL PROTECTED] > Subject: RE: Faster Inserting Code > > > The select statement gets 30,000+ records. After 10 > minutes of inser

RE: Faster Inserting Code

2004-09-22 Thread Lamb Joseph
r. Where are things slow? What are > your expectations? > > - > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > > -Original Message- > From: Lamb Joseph [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 22, 2004 2:05 PM > To:

RE: Faster Inserting Code

2004-09-22 Thread Reidy, Ron
Inserting Code I would like to know how to insert faster using SQLite. use strict; use dbi; use Date::Manip; use Diagnostics; #Connect to the database my $dbh = DBI->connect("dbi:SQLite:data.dbl") || die "Cannot connect: $DBI::errstr"; #MSSQL Server my $kewilldb = 'LV

Faster Inserting Code

2004-09-22 Thread Lamb Joseph
I would like to know how to insert faster using SQLite. use strict; use dbi; use Date::Manip; use Diagnostics; #Connect to the database my $dbh = DBI->connect("dbi:SQLite:data.dbl") || die "Cannot connect: $DBI::errstr"; #MSSQL Server my $kewilldb = 'LV_KWARCHIVE'; my $dbh_kewill = DBI->conne