Hi @atom_yang, To examplify what @geraldss mentioned, with union all you could write a single statement that take key1…key6 and execute this in one batch. you add some more smartness like:
curl -v http://127.0.0.1:8093/query/service
-d ‘statement=PREPARE getResByKey1AndKey2 FROM
SELECT a.value from mydb a where a.key1 == $key1 and a.key2 == $key2 and $key1 is not null and $key1 is not missing and $key2 is not null and $key2 is not missing
UNION ALL
SELECT a.value from mydb a where a.key1 == $key1 and a.key2 == $key2 …
UNION ALL …’
May I ask what type of an app you are building and why this capability is important to you?
Thanks