On Apr 5, 2005, at 1:33 AM, Andrei Reinus wrote:
> Hi,
>
> I have few questions about PREPARE statements.
> As starting a new project, I always try to find ways to 'do-it-right'
> and application is
> all OLTP style system.
>
> I have lots of queries like "SELECT name FROM client WHERE id = 1".
> Plain and simple PK index search.
> To save parsing/rewriting/planning overhead I should use PREPARE
> statements, right?
>
I'm not an expert here, so listen for others to weigh in. However, if
you are executing the prepared statement more than once per connection,
that is true....
> Manual states that prepare statements are only stored in database
> session,
> is there are way to be sure that statement exists or make it last over
> all sessions?
How about a stored procedure?
> I cant PREPARE statments over and over again with every page request,
> right?
Are you in a persistent environment where you can reuse the same
database connection?
Sean