You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@camel.apache.org by "Claus Ibsen (Jira)" <ji...@apache.org> on 2021/07/05 16:30:00 UTC
[jira] [Resolved] (CAMEL-16770) Add support for caching JDBC
Idempotent Repository
[ https://issues.apache.org/jira/browse/CAMEL-16770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Claus Ibsen resolved CAMEL-16770.
---------------------------------
Resolution: Fixed
> 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)