Introduce sth caching to Letters.pm
authorJoe Atzberger <joe.atzberger@liblime.com>
Fri, 27 Mar 2009 15:34:34 +0000 (10:34 -0500)
committerGalen Charlton <galen.charlton@liblime.com>
Wed, 8 Apr 2009 18:01:23 +0000 (13:01 -0500)
commit35c8a5be58ffff4324fbb7ccf19364552563853d
tree069e760a4a38ad34176675b57d9f2e626e00c336
parent60761e44aefca3bb96d2b43e5e8c70a9f3ad1516
Introduce sth caching to Letters.pm

The re-creation of statement handles for the same queries, repeatedly,
seriously degrades the performance of notices.  This introduces new
class-level caching to avoid that problem.

Note: initial provisions
to do the same with caching of COLUMNS information about tables is
also included, but this would probably be most usefully implemented
in C4::Context (or a separate more central module).  The benefits of
caching that info would probably be even greater.  Note that this
proposed implementation might be obsoleted by ORM integration, where
DB structure info would already be cached.

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
C4/Letters.pm