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;

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 some? I'm still new to database programming

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, , Rob