Re: questions on serving big file & SQL statement parsin

["Perrin Harkins" <suppressed>]

On 7/2/07, James. L <suppressed> wrote:
> 1. "SQL statement parsing" is mentioned in the doc:
> http://perl.apache.org/docs/1.0/guide/performance.html#toc_Eliminating_SQL_Statement_Parsing
>
> i am curious that if it is a general practice(caching
> sql statement in package variable to avoid parsing) to
> do the My::DB thing in mod_perl app ?

No, in most cases it's better to use prepare_cached instead.  It's a
little slower, but it can survive reconnecting the database handle.

- Perrin