Re: Querying 30K data from geode region

Cool, creating an index will definitely help here. create an index on userID On Wed, Jul 5, 2017 at 11:13 AM Amit Pandey wrote: > Yes Projection is a good idea. > > On Wed, Jul 5, 2017 at 11:42 PM, Amit Pandey > wrote: > >> Its pretty

Re: Querying 30K data from geode region

Yes Projection is a good idea. On Wed, Jul 5, 2017 at 11:42 PM, Amit Pandey wrote: > Its pretty simple like :- > > select * from /orders where userID=1; > > I know the syntax is not correct. > > So you are saying to add some index or userID > > On Wed, Jul 5, 2017 at

Re: Querying 30K data from geode region

Adding to what Swapnil suggested, assuming you are only interested in a few of the fields and not the entire object, try adding a projection field to the query. This might improve performance as less data would need to be serialized to a client. I'd definitely try adding an index (some queries