> > The docs for prepare_cached() are littered with "Don't do this unless
> > you understand the implications" warnings, as well as some kludges to
> > differentiate different cases.
> Which is why Vlad should use prepare() instead of prepare_cached().
in our web application similar SQL queries (like load an object)
executed over and over again with high frequency. So it's very
desirable to use prepare_cached. I think we are going to adjust our
ORM (object relation mapper) to always use full path to reference DB
objects in query.
In response to
pgsql-general by date
|Next:||From: Jonel Rienton||Date: 2005-05-02 18:56:04|
|Subject: PostgreSQL 8.0.2 and Tiger|
|Previous:||From: Joshua D. Drake||Date: 2005-05-02 18:27:27|
|Subject: Re: Tuning queries inside a function|