tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Howard W. Smith, Jr." <smithh032...@gmail.com>
Subject Re: TomEE performance degrades gradually
Date Fri, 04 Apr 2014 11:28:20 GMT
On Fri, Apr 4, 2014 at 7:21 AM, Jean-Louis MONTEIRO <jeanouii@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! :)

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message