Perrin Harkins wrote:
>
> On Thu, 14 Oct 1999, Jeffrey Baker wrote:
> > Zero optimization: 41.67 requests/second
> > Stage 1 (persistent connections): 140.17 requests/second
> > Stage 2 (bound parameters): 139.20 requests/second
> > Stage 3 (persistent statement handles): 251.13 requests/second
>
> I know you said you don't like it because it has extra overhead, but would
> you mind trying stage 3 with prepare_cached rather than your custom
> solution with globals? For some applications with lots of SQL statements,
> the prepare_cached appraoch is just much more manageable.
Okay. I'll try it out tomorrow and post the results. However, my
application uses this approach and I'd say it's in the 99th percentile
with respect to number of different statements =:-)
Regards,
Jeffrey
