Sybase and/or MSSQL?

[David Miller]

On 5/22/2003 9:46 PM +1000, Bradley Baetz wrote:

> On Thu, May 22, 2003 at 07:35:38AM -0400, David Miller wrote:
>> Sure, because using placeholders puts it in a stored procedure temporarily
>> (which caches the query plan).  Unfortunately that's a rather large price
>> to pay, even once, and it normally only used once anyway, unless mod_perl
>> is working and it can be cached between connections.
>
> Thats not what I meant. Oracle will cache the plan in the shared pool,
> to be shared by all backends. Can't you just turn off its optimisaton
> stuff for the simple queries?

Our DBA hasn't found a way to do that yet.
-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/