Yes Projection is a good idea. On Wed, Jul 5, 2017 at 11:42 PM, Amit Pandey <[email protected]> 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 11:33 PM, Swapnil Bawaskar <[email protected]> > wrote: > >> You can look into adding an index >> <http://geode.apache.org/docs/guide/11/developing/query_index/query_index.html>. >> What is the query? >> >> On Tue, Jul 4, 2017 at 7:44 AM Amit Pandey <[email protected]> >> wrote: >> >>> Hey Guys. >>> >>> I am querying some 30K data from a region. Its aPOJO with around 20 >>> fields, using PDX. >>> >>> It takes around 20 seconds for this. is there any other way to optimize >>> this? >>> >>> Regards >>> >> >
