in reply to Re: mod_perl was hosed by a bind variable
in thread mod_perl was hosed by a bind variable

If you switch to using prepare_cached for the xbind version, it should make a difference. It would not be possible to use prepare_cached for the xinline version in most cases, since that would results in a new query being cached and held in memory for every possible value of id. Also, you should actually do the variable substitution in xinline to make this realistsic, i.e. "id = $id".
  • 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 fireartist (Chaplain) on Jan 30, 2004 at 16:48 UTC
    I know that prepared_cache would make a big difference, but I wasn't interested in testing that, just the queries that were shown in the root node.
    Thanks for pointing it out though.