Re: More on web application performance with DBI

[Mark D. Landry]

> > Actually not - Sybase creates a temporary stored proc for each prepared
> > statement, so it's equivalent to using stored procedures.
>
> Heh neat, is that DBD::Sybase or the server that's doing that?
> And does it only work for a single statement handle or does it keep
> that procedure around in case i prepare the same statement again?

The driver creates the stored procedure in the prepare method. Subsequent prepare
yields another stored procedure. Avoid preparing the same statement more than
once. Use placeholders.