> "R" == Rudy <[EMAIL PROTECTED]> writes:
R> prepare all your database handles only once!
R> read: perldoc DBI
R> vassst improvements will be noticed. Even if you
R> don't use Perl, the theory is the same.
It depends a lot on your actual database server. For some, it matters
not a bit
[ date ] 2000/06/22 | Thursday | 06:08 AM
[ author ] Rudy <[EMAIL PROTECTED]>
> prepare all your database handles only once!
> read: perldoc DBI
> vassst improvements will be noticed. Even if you
> don't use Perl, the theory is the same.
You might want to look into the prepare_cached()
prepare all your database handles only once!
read: perldoc DBI
vassst improvements will be noticed. Even if you
don't use Perl, the theory is the same.
I usually make a global-prepared-statement hash for each child and run
the prepares in a BEGIN block.
%prepped = { table => $dbh->prepare
