a lot of sql query isn't necessary cache
for improve performance, query convert to postgresql is cached.
but in case query don't use PreparedStatement to pass parameter like:
+ add row access condition,
+ build where condition like on info window, find panel.
cache is increase but query is race to reuse.
need to improve:
+ add flag to don't cache sql query on some condition.
+ optimize to pass parameter to PreparedStatement, avoid dynamic build where condition.
Closing as potential idea.
Hi , maybe we can start by identifying some common cases non-worthy to cache, for example:
insert statement with values
update or delete statements with numeric constants >= 1000000 in the where clause