Prepared statements vs. Stored Procedures

From: Oliver Crosby <ryusei(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Prepared statements vs. Stored Procedures
Date: 2005-06-21 19:46:03
Message-ID: 1efd553a05062112462c30e9ff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm hoping someone can offer some advice here.
I have a large perl script that employs prepared statements to do all its
queries. I'm looking at using stored procedures to improve performance times
for the script. Would making a stored procedure to replace each prepared
statement be worthwhile? If not, when could I use stored procedures to
improve performance?
Thanks in advance.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tobias Brox 2005-06-21 19:46:39 Re: Limit clause not using index
Previous Message Yves Vindevogel 2005-06-21 19:30:50 Re: Another question on indexes (drop and recreate)