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 will not take advantage of the index- such as "select * from /region r" - there is nothing to filter out) On Wed, Jul 5, 2017 at 11:03 AM 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 >> >
