[Rt-devel] [PATCH] Quote identifiers.

Robert Spier rspier at pobox.com
Sat Jan 22 15:12:36 EST 2005


>                  Rate without $dbh    with $dbh
> without $dbh 43465/s           --         -40%
> with $dbh    72127/s          66%           --
> 
> Something similar happens in sub Insert I call quote_identifier in map
> context for each column, also dbh sub in SB::Handle more complex then
> in benchmark.
> 

Potential Micro-optimization.  How often are these really called?  

Benchmarks that show improvements in tight loops are great, and I love
them, but when the code isn't actually run in a tight loop, it's kind
of meaningless.

For this kind of statement I'd guess that the time required to
actually run the kind of database queries we run greatly dwarfs the
time saved by using a temporary.  Kind of like a shortcut that saves 5
minutes out of a five hour drive.

-R


More information about the Rt-devel mailing list