Re: Slow Postgres Update

2002-08-27 Thread Randal L. Schwartz
> "Rob" == Rob <[EMAIL PROTECTED]> writes: Rob> How can I speed it up some? I'm still new to database programming with Rob> Perl so if you see anything else that I'm doing wrong or could do better Rob> don't hesitate to point it out. [...] Rob> my $dbh = DBI->connect($database, $db_user, ""

Re: Slow Postgres Update

2002-08-27 Thread Bob Showalter
- Original Message - From: "Rob" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 4:00 PM Subject: Slow Postgres Update > The below updates a database from a very large file but it's rather slow; > How can I speed it up

Slow Postgres Update

2002-08-27 Thread Rob
The below updates a database from a very large file but it's rather slow; How can I speed it up some? I'm still new to database programming with Perl so if you see anything else that I'm doing wrong or could do better don't hesitate to point it out. #!/usr/bin/perl -w use strict; use DBI; my($