[
https://issues.apache.org/jira/browse/CAMEL-16770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Claus Ibsen updated CAMEL-16770:
--------------------------------
Fix Version/s: 3.12.0
> Add support for caching JDBC Idempotent Repository
> --------------------------------------------------
>
> Key: CAMEL-16770
> URL: https://issues.apache.org/jira/browse/CAMEL-16770
> Project: Camel
> Issue Type: New Feature
> Components: camel-sql
> Affects Versions: 3.11.0
> Reporter: Michael Genereux
> Priority: Major
> Fix For: 3.12.0
>
>
> The JDBC Idempotent Repository does a full transactional query on every check
> by the Idempotent Consumer. On SQL Server implementations that have a high
> overhead per query, each query can take two seconds. For a 1000 checks, this
> can take a half hour. My proposal is to cache the repository list in a
> single query and then reference that list in memory.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
