You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Mahesh Renduchintala <ma...@aline-consulting.com> on 2019/12/26 12:29:05 UTC
NearCache for SQL tables
Hi,
is there a way to create near cache on CLIENT nodes for SQL tables?
regards
Mahesh
Re: NearCache for SQL tables
Posted by Denis Magda <dm...@apache.org>.
Manesh,
How many server nodes do you have in total and have you tried to perform
SQL optimizations listed below?
https://www.gridgain.com/docs/latest/perf-troubleshooting-guide/sql-tuning
Denis
On Thursday, December 26, 2019, Mahesh Renduchintala <
mahesh.renduchintala@aline-consulting.com> wrote:
> Dennis,
>
> We use ignite for supply chain management usecases and almost all are SQL
> schemas
>
> In replicated mode, for large tables and for a single query, the data
> reads are happening from ram and disk of a single node.
> We measured a 4-time increase in query latencies (reads) in replicated
> mode compared to partitioned mode. This is possible due to the disk coming
> into play.
>
> I was thinking a near cache at client node might improve read latencies.
>
> We find replicated mode much more suited than partitioned mode due to high
> availability needs. We also reported several issues with JOINS in
> partitioned mode and this is a show stopper for us in production
> deployments. Replicated mode does not have these issues with join and is a
> simple solution for backup and restore.
>
> regards
> Mahesh
>
>
--
-
Denis
Re: NearCache for SQL tables
Posted by Mahesh Renduchintala <ma...@aline-consulting.com>.
Dennis,
We use ignite for supply chain management usecases and almost all are SQL schemas
In replicated mode, for large tables and for a single query, the data reads are happening from ram and disk of a single node.
We measured a 4-time increase in query latencies (reads) in replicated mode compared to partitioned mode. This is possible due to the disk coming into play.
I was thinking a near cache at client node might improve read latencies.
We find replicated mode much more suited than partitioned mode due to high availability needs. We also reported several issues with JOINS in partitioned mode and this is a show stopper for us in production deployments. Replicated mode does not have these issues with join and is a simple solution for backup and restore.
regards
Mahesh
Re: NearCache for SQL tables
Posted by Denis Magda <dm...@apache.org>.
Hello Mahesh,
The near cache works only for key-value APIs. Why would you have for SQL,
what's your usage scenario or issue?
-
Denis
On Thu, Dec 26, 2019 at 4:29 AM Mahesh Renduchintala <
mahesh.renduchintala@aline-consulting.com> wrote:
> Hi,
>
> is there a way to create near cache on CLIENT nodes for SQL tables?
>
>
> regards
> Mahesh
>
>