Re: Perl DBI, PostgreSQL performance question - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Perl DBI, PostgreSQL performance question
Date
Msg-id 3.0.5.32.20011215184148.017f6e70@192.228.128.13
Whole thread Raw
In response to Perl DBI, PostgreSQL performance question  (Benjamin Franks <benjamin@dzhan.com>)
List 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pl/Tcl problem
Next
From: Trond Eivind Glomsrød
Date:
Subject: Re: Pl/Tcl problem