ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dkarachentsev <dkarachent...@gridgain.com>
Subject Re: Get a Key from cache vs SQL Indexed parameter search performance
Date Mon, 26 Dec 2016 14:06:43 GMT
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.

Mime
View raw message