[Phoenix-pm] PERL DBI

[Scott Walters]

Hi Peter,

Reading through a bit, your repeated question of whether autoinsert is on
hasn't been answered.  The rest of you on this list, except Andrew,
Brock, and Michael, suck.  I don't know the exact version or the version
of DBI you're using, but newer versions do indeed turn it in by default.
You can turn it off in the connect string...

  DBI->connect(mush, username, pass, { AutoCommit => 0 });

Then BEGIN and COMMIT as you please.  

Cheers,
-scott

On  0, "Loo, Peter # PHX" <Peter.Loo at source.wolterskluwer.com> wrote:
> 
> You are a funny guy.  :)  I think I will type the data in manually.  :)
>  
> Peter Loo
> Wolters Kluwer Health
> (602) 381-9553
> 
> -----Original Message-----
> From: Brock [mailto:awwaiid at thelackthereof.org] 
> Sent: Monday, March 13, 2006 3:04 PM
> To: Loo, Peter # PHX
> Cc: Scott Walters; phoenix-pm at pm.org
> Subject: Re: [Phoenix-pm] PERL DBI
> 
> I say not too bad... 2 and a half million records is nothing to sneeze
> at. Thats just over 467 rows/sec, I figure. Lot faster than doing it by
> hand! :)
> 
> Ideas for presentations:
> * DBI
> * Profiling Perl Code
> 
> --Brock
> 
> On 2006.03.13.14.37, Loo, Peter # PHX wrote:
> | 
> | Here is what it took to run:
> | 
> | Mon Mar 13 13:05:34 MST 2006
> | Mon Mar 13 14:31:27 MST 2006
> | 
> | SQL> select count(*) from dssppv.tmp_falcon_projections;
> | 
> |   COUNT(*)
> | ----------
> |    2413059
> 
> 
> This E-mail message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information.  Any unauthorized
> review, use, disclosure or distribution is prohibited.  If you are not
> the intended recipient, please contact the sender by reply E-mail, and
> destroy all copies of the original message.
> 
> 
> This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
> _______________________________________________
> Phoenix-pm mailing list
> Phoenix-pm at pm.org
> http://mail.pm.org/mailman/listinfo/phoenix-pm