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 < [email protected]> 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
