You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Anghel Botos (JIRA)" <ji...@apache.org> on 2017/01/04 08:32:58 UTC

[jira] [Resolved] (IGNITE-4164) Add support for parallel loading of caches using custom SQL load queries in org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore#loadCache

     [ https://issues.apache.org/jira/browse/IGNITE-4164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anghel Botos resolved IGNITE-4164.
----------------------------------
    Resolution: Won't Fix

The workaround suggested in the comments is a working solution.

> Add support for parallel loading of caches using custom SQL load queries in org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore#loadCache
> -----------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-4164
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4164
>             Project: Ignite
>          Issue Type: Improvement
>          Components: cache
>    Affects Versions: 1.7
>            Reporter: Anghel Botos
>
> Please add support for parallel loading of caches using custom SQL load queries in org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore#loadCache. For the moment this is not possible, as the current implementation performs the load for each entity type in the cache using a single {{LoadCacheCustomQueryWorker}}, as opposed to the the approach that is used when no custom SQL queries are provided for the load, where for each entity type, the load is distributed across several threads based on some ranges.
> While it may not be possible to support parralel load with any custom SQL query (as this would mean that Ignite would have to somehow understand the meaning of that custom query), it would still be a significant improvement if it would be possible to have the parallel load when providing a custom {{WHERE}} clause for each entity type (instead of a full custom query).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)