Re: Queries on key fields

2018-10-02 Thread siby_sekar
Thank you Jason that was really helpful. Can we use index and PDXSerialization together on a field. Here in this case we will be searching by sessionId, but should we assign just PDxSerialization or index or can we use both on sessionId ? thanks, Siby. -- Sent from: http://apache-geode-incuba

Re: Queries on key fields

2018-09-29 Thread siby_sekar
for us sessionId is not the actual key field. It will be something like some arbitrarystring+sessionid and we will be running queries with - like "%sessionId%" to find all entries having a particular sessionid. In this case to improve performance can we apply any index ? is this approach bet

Re: Queries on key fields

2018-09-29 Thread siby_sekar
Thank you. I have more queries on the topic. we will be applying queries like 1. key like "%sessionID% as sessionid will not be the actual key. we will have several objects where same sessionid is going to be part of multiple objects and we will have to get all objects that contains a partic

Queries on key fields

2018-09-28 Thread siby_sekar
Which is more performant running queries on key fields or non key fields? we have an object in the form sessionid : { Listmessages} and message can be like { id1, sessionid, name } etc. -- Sent from: http://apache-geode-incubating-developers-forum.70738.x6.nabble.com/