You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/07/13 06:28:00 UTC
[jira] [Commented] (IGNITE-5382) SQL: frequent switch between
schemas cause severe slowdown
[ https://issues.apache.org/jira/browse/IGNITE-5382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16085253#comment-16085253 ]
ASF GitHub Bot commented on IGNITE-5382:
----------------------------------------
GitHub user skalashnikov opened a pull request:
https://github.com/apache/ignite/pull/2290
IGNITE-5382: SQL: Added per-schema connection lookup
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-5382
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/2290.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #2290
----
commit 9b59c095cb368fee0fedcc0a2781fdc5b55a9951
Author: skalashnikov <sk...@gridgain.com>
Date: 2017-07-13T06:21:52Z
IGNITE-5382: SQL: Added per-schema connection lookup
----
> SQL: frequent switch between schemas cause severe slowdown
> ----------------------------------------------------------
>
> Key: IGNITE-5382
> URL: https://issues.apache.org/jira/browse/IGNITE-5382
> Project: Ignite
> Issue Type: Task
> Components: cache, sql
> Reporter: Vladimir Ozerov
> Assignee: Sergey Kalashnikov
> Labels: important, performance
> Fix For: 2.2
>
>
> We have thread-bound cached connection to H2 database which is bound to specific schema. See {{IgniteH2Indexing.connectionForThread}}.
> When query with different schema is executed, we call {{SET SCHEMA}} command, which is rather expensive and may cause slowdown when queries form different caches are executed.
> To avoid this we should maintain thread-local map of such connections. Be careful with concurrency and resource leaks.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)