Sybase and/or MSSQL?

[David Miller]

On 5/22/2003 8:54 PM +1000, Bradley Baetz wrote:

> On Wed, May 21, 2003 at 07:57:42PM -0400, David Miller wrote:
>> Sybase will spend 13 seconds analyzing and generating a query plan for a
>> query that takes .5 seconds to run once it actually runs it, and MySQL runs
>> the same query (including plan generation) in that same .5 seconds
>
> If you use placeholders, will sybase optimise it for you like Oracle
> does, and so you only pay that price once?

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.
-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/