On Fri, Apr 4, 2014 at 7:21 AM, Jean-Louis MONTEIRO <jeano...@gmail.com>wrote:
> I tend to disagree with that. > Each part of a system has it's own goal and scope. > > Database is for data so I tend to use it as much as possible for sorting, > joining, etc, instead of relaying on Java for sorting collections or even > JPA to get a parent, then all childs, then all childs but applying a > filter. > > But I would agree on the sense that each part (App Server, Database, etc) > must be tuned according to your SLA and the overall architecture. > So yes, take care of returning a large resultset to avoid heavy GC > workload, and check if you have an index and if it's used (explain in mysql > or any other database specific way to check the execution plan). > > JLouis > > +1 I agree, Jean-Louis. Thanks! :)