Cool, creating an index will definitely help here. create an index on userID
On Wed, Jul 5, 2017 at 11:13 AM Amit Pandey <[email protected]> wrote: > 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 >>>> >>> >> >
