There's not much overhead simply by enabling SQL, but there's obviously a cost to maintaining any indexes you create. Normally the cost of maintaining those indexes is more than offset by improvements in query performance. But the only real way to tell for your use case is to benchmark it.
On Wed, 28 Feb 2024 at 21:58, Dinakar Devineni <dina....@gmail.com> wrote: > > > Hi, > > > > I’m planning to enable and use SQL API for existing Caches by adding > all fields are quarriable fields. Will this affect the performance of > Key-Value API Cache gets & puts. > > And are there any side affects, like increased memory usage, reduced > performance of cluster using SQL API, that one should be aware of before > promoting it? > > > > Ignite Version : 2.14.0 > > > > > > Thanks > > dina >