Sybase and/or MSSQL?

Bradley Baetz bbaetz at acm.org
Thu May 22 11:46:15 UTC 2003


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?

Bradley



More information about the developers mailing list