Re: More on web application performance with DBI

[Matt Sergeant]

On Fri, 15 Oct 1999, 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.

Sadly prepare_cached doesn't always work very well - at least not with
Sybase (and I assume MSSQL). Just a warning.

--
<Matt/>

Details: FastNet Software Ltd - XML, Perl, Databases.
Tagline: High Performance Web Solutions
Web Sites: http://come.to/fastnet http://sergeant.org
Available for Consultancy, Contracts and Training.