Re: questions on serving big file & SQL statement parsin

[Perrin Harkins]

On 7/2/07, James. L <[EMAIL PROTECTED]> 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