IgniteH2Indexing caches prepared statements in stmtCache that uses Threads as keys. Under they high load when there are many Threads the cache can grow significantly. Plus if a Thread is terminated its prepared statements are not get cleaned introducing a memory leak.
A special background Thread should be introduced that will iterate over stmCache performing the following:
- cleaning records for terminated Threads;
- cleaning records of the Threads that were not used for a long time. A special configuration parameter can be set.