Is it possible to search on both KEY and VALUE!!!
I would like to write an application which can search 500 TPS (Transaction per Second) from 200 million records. The search will be done on both Key and Value.
A KEY will have 999 values with comma separator (001, 002, 010, 020, 100, 101, 102, 909, 999, etc..) and will have ‘n’ number of keys.
Sample number will have 6(123456) digits and the key value will be first 3(123) digits and value will be last 3(456) digits.
Is it possible to search on both KEY and VALUE? From my C++ application I will pass both KEY (123) and VALUE (456), it should return value is present or not in the KEY.
Kindly advise on the same.