Get a Key from cache vs SQL Indexed parameter search performance

[Oru <de...@gmail.com>]

Hi There!

I am currently writing my java program to access ignite cache primarily by
using IgniteCache's .get method.

Is it advisable to use indexed SQL based queries (for performance reason
only) ? or the search speed of both is the same?

Thanks
Oru



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Get-a-Key-from-cache-vs-SQL-Indexed-parameter-search-performance-tp9734.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Get a Key from cache vs SQL Indexed parameter search performance

[dkarachentsev <dk...@gridgain.com>]

Hi Oru,

If you need just key/value operations then simple get() will be much faster
than SQL queries. Because indexing, parsing and processing query consumes
resources.

But if you need quite often search for cache entities by their fields, using
of SQL + indexes is preferable, because no need to scan all cache entries.

Thanks!



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Get-a-Key-from-cache-vs-SQL-Indexed-parameter-search-performance-tp9734p9737.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.