[IGNITE-5382] SQL: frequent switch between schemas cause severe slowdown

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Component/s: cache, sql
• Labels: sql-performance
• Assignee: Unassigned
• Reporter: Vladimir Ozerov
• Created: 01/Jun/17 11:43
• Updated: 01/Aug/19 22:05
• Resolved: 16/Nov/18 17:22

Description

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.

Issue Links

• links to: GitHub Pull Request #2290
• links to: GitHub Pull Request #2290