INSERT query that UPDATES if record already found

2018-07-26 Thread olg.k...@gmail.com
Hi There, I'm using Ignite 2.4 with JDBC mainly as an in mem Cache and looking for a way to write the fastest query to insert new record but if a record with the same key already exists I would like it to be updated. DDL looks like this: CREATE TABLE PERSON ( Id VARCHAR, name VARCHAR, PRIMAR

Ignite spatial index behavior

2018-04-15 Thread olg.k...@gmail.com
Is there an optimization about spatial index behavior? I'm running a POC, trying to show Ignite performance when searching for a polygon (from a polygon table) which intersects with a certain point (randomly generated). I've noticed that when the 'hit-ratio' is low (no intersecting polygon) the que