Re: Perl DBI, PostgreSQL performance question

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Benjamin Franks <benjamin(at)dzhan(dot)com>, <dbi-users(at)perl(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Perl DBI, PostgreSQL performance question
Date: 2001-12-15 10:41:48
Message-ID: 3.0.5.32.20011215184148.017f6e70@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 07:35 AM 12/14/01 -0800, Benjamin Franks wrote:
>I'm using the Perl DBI to interact with my PostgreSQL 7.1.3 database. I
had a section of code that looked something like the
>following (it's only pseudocode):
...
>block to two eval blocks with some statements outside the eval? What
about multiple commits--could they be expensive
>operations?

Yep commits are expensive.

Reducing the number of commmits needed might speed things up.

Good luck,
Link.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trond Eivind Glomsrød 2001-12-15 14:19:04 Re: Pl/Tcl problem
Previous Message Raymond C. Rodgers 2001-12-15 08:01:38 Re: 7.2 back to 7.1.3