Re: Performance problems with prepared statements

Theo Kramer wrote:
> On Thu, 2007-10-11 at 18:28 +0000, Andrew - Supernews wrote:
>> When you do this from the application, are you passing it 3 parameters,
>> or 5?  The plan is clearly taking advantage of the fact that the two
>> occurrences of $1 and $2 are known to be the same value; if your app is
>> using some interface that uses ? placeholders rather than numbered
>> parameters, then the planner will not be able to make this assumption.
> 
> You may just have hit the nail on the head. I use numbered parameters
> but have $1 to $5 ... let me take a look to see if I can change this.

That'll be it.

-- 
   Richard Huxton
   Archonet Ltd