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.
Environment
None
Activity
Show:
Carlos Ruiz October 15, 2019 at 2:41 PM
Closing as potential idea.
Carlos Ruiz July 17, 2019 at 9:49 AM
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
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.