a lot of sql query isn't necessary cache

Description

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
July 17, 2019, 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

 

 

Carlos Ruiz
October 15, 2019, 2:41 PM

Closing as potential idea.

Assignee

Unassigned

Reporter

Hiep Lq

Labels

Tested By

None

Priority

Major
Configure