Re^2: mod_perl was hosed by a bind variable (tangent)

Since perrin keeps pressing this point, I wanted to mention that, though perrin's advice is reasonable, this first conclusion ("You must have been preparing the query every time then") doesn't make any sense in the situation being discussed.

If someone complains that using a placeholder makes their code much slower, then caching the query cannot be part of the explanation, since the "fast" case makes it impossible to cache the query so caching could only explain it if caching made things slower.

- tye

Comment on Re^2: mod_perl was hosed by a bind variable (tangent)

Replies are listed 'Best First'.
Re: Re^2: mod_perl was hosed by a bind variable (tangent) by perrin (Chancellor) on Jan 30, 2004 at 20:53 UTC
If someone complains that using a placeholder makes their code much slower, then caching the query cannot be part of the explanation That was my point, actually: that if not using placeholders appeared to make it faster, then he must not have been caching the query, which means he was missing out on a large part of the speed offered by placeholders.	[reply]