If possible, create an index on relevant fields that the query can take advantage of.
-Jason On Fri, Jan 12, 2018 at 8:50 AM Amit Pandey <[email protected]> wrote: > Actually I plan to do that, but do get the data I need to query. > > My plan is to only get local data from Query (and I want to optimize this > as much as possible). > > Regards > > On Fri, Jan 12, 2018 at 10:03 PM, Jacob Barrett <[email protected]> > wrote: > >> Amit, >> >> You’re better off processing the data in place. Can you write your >> processing as a function that can execute on each node and process only the >> local data and returning only the results of that processing to your client? >> >> If your going to continue with queries then yes, faster serialization can >> be achieved through implementing DataSetializable. >> >> -Jake >> >> >> > On Jan 11, 2018, at 11:28 PM, Amit Pandey <[email protected]> >> wrote: >> > >> > Hi Guys, >> > >> > I have a query which fetches some 30,000 rows in a single machine. >> > I want to get under a second if possible or much lesser and do some >> processing on it. >> > I have some indexes is it possible to give me some tips on Optimizing >> performance? >> > >> > Does implementing DataSerializable in domain class help ? I am using >> ReflectionbasedSerializer. >> > >> > Regards >> > >
