Is it possible to search on both KEY and VALUE!!!
Hi,
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.
Regards,
Ravichandra.
As far as I know there is a limit of 250 characters for the key, so 999 values won't work for the key unfortunately. Source: Memcache protocol (https://github.com/memcached/memcached/blob/master/doc/protocol.txt) scroll down to section label "Keys"
Ari is correct here. I read this as the key would be a sorted set though, and not necessarily violate the number of characters restriction. Maybe I read it incorrectly though.
Still, given that Couchbase Server 2.0 is required, you'll be able to put the data in the body of the document. We usually recommend having a natural key for the document, but it's not strictly required.
It is possible to search on both key and value using Couchbase Server 2.0. Please have a look at views in Couchbase Server 2.0. They'll help you do what you want.