impossibl/pgjdbc-ng — pull request #61 by brettwooldridge (2014-01-21 14:51:47+00:00)
Title: Introduce a parsed SQL cache for SQLText hierarchies.

Ok this is a freshened-up pull request. I added the ability to configure the cache size and removed the dependency on Google ConcurrentLinkedHashMap. Note also that this does not use Java serialization, it uses custom code to perform the copy which perform almost an order of magnitude faster than standard (notoriously slow) Java serialization.

Unlike the (forthcoming) prepared statement cache which will default to 'off', the parsed SQL cache defaults to 'on' because it not only improves performance, with no side-effects, but also reduces GC pressure which we should view as a good thing. One of the primary goals of Netty4 was reducing GC pressure, because in a long-running high-performance system it starts to become an issue.