Re: Re: mod_perl was hosed by a bind variable

I could not find any significant slowdown between the 'bind' and the 'inline' version of the script, so I must conclude that the huge difference you found must come from somewhere else.

Note that there's a subtle, but possibly highly significant, difference between the way you're generating your inline query and the way the OP generates his.

Comment on Re: Re: mod_perl was hosed by a bind variable

Replies are listed 'Best First'.
Re: Re: Re: mod_perl was hosed by a bind variable by CountZero (Bishop) on Jan 31, 2004 at 08:16 UTC
Yes, but it was my intention to check whether there was a difference between the 'bind' and the 'inline' versions over cgi and mod-perl execution using very similar syntax in both versions, the only difference being the use of the '?' placeholder. I did not expect any difference (placeholders being emulated in DBD:MySQL), nor could I indeed find any significant difference, leading me to conclude that there is no interference between cgi/mod-perl as far as using place-holders is concerned. So the reason must be found somewhere else. Update: I tried using the `$sth->bind_param(1, $parameter)` to see if it made a difference: nope, all remained the same (within the to be expected statistical variations). So either it must be a data-issue (seems rather far-fetched) or something with the OP's code (but we haven't seen it, so I cannot comment). CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: Re: mod_perl was hosed by a bind variable
by CountZero (Bishop) on Jan 31, 2004 at 08:16 UTC

I did not expect any difference (placeholders being emulated in DBD:MySQL), nor could I indeed find any significant difference, leading me to conclude that there is no interference between cgi/mod-perl as far as using place-holders is concerned.

So the reason must be found somewhere else.

Update: I tried using the $sth->bind_param(1, $parameter) to see if it made a difference: nope, all remained the same (within the to be expected statistical variations).

So either it must be a data-issue (seems rather far-fetched) or something with the OP's code (but we haven't seen it, so I cannot comment).

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

[reply]
[d/l]