i have 50M of DB. i don't think that it can take down the instance.
but i set
-Xmx32m
and nothing changed.
i think that is not in settings. that is something fundamental.
any ideas?
2012/5/4 Ramsey Gurley rgur...@smarthealth.com
If you are fetching tens of thousands of rows for a list page,
Am 10.05.2012 um 09:49 schrieb Ron X:
i have 50M of DB. i don't think that it can take down the instance.
but i set
-Xmx32m
32MB is quite small, try with -Xms512m -Xmx1024m and see if your problem goes
away
and nothing changed.
i think that is not in settings. that is something
ESs-Mac:~ user$ top
5340 java 94.2 01:40.99 42/1 1370 393 487M+ 9124K 525M+
RuntimeException: Statement running too long
at
er.extensions.eof.ERXEOAccessUtilities.logExpression(ERXEOAccessUtilities.java:1213)
at
Your fetch is taking too long. What is the SQL that is sent to your db? How big
is the resultset you are expecting? Perhaps your indexes are broken (you have
indexes, don't you)?
jw
Am 10.05.2012 um 10:37 schrieb Ron X:
ESs-Mac:~ user$ top
5340 java 94.2 01:40.99 42/1 1370
i use Navicat to see the DB
so select * from Song was 0.8 sec.
but in code the same query:
ERROR 150.87 MB used/359.07 MB free [WorkerThread2]
(ERXEOAccessUtilities.java:1213) Page:
er.modern.look.pages.ERMODQueryEntitiesPage - Configuration: null -
Song@116895853 expression took 16567 ms:
that was in debug mode.
in run-mode:
WARN 422.22 MB used/87.72 MB free [WorkerThread3]
(ERXNSLogLog4jBridge.java:43) (ListSong) -
er.extensions.appserver.ERXComponentRequestHandler: Exception occurred
while handling request:
java.lang.ClassCastException: java.lang.String cannot be cast to
Am 10.05.2012 um 10:44 schrieb Ron X:
i use Navicat to see the DB
so select * from Song was 0.8 sec.
but in code the same query:
ERROR 150.87 MB used/359.07 MB free [WorkerThread2]
(ERXEOAccessUtilities.java:1213) Page:
er.modern.look.pages.ERMODQueryEntitiesPage - Configuration:
Ron:
Johann's suggestion was the best course of action. Review the SQL that the app
is producing for the request in question. Post back to the list all of the
exact queries this single request is executing.
Tim
On May 10, 2012, at 2:22 AM, Ron X ron.x.by...@gmail.com wrote:
maybe i have
Looks like you're using the wrong assignment class and assigning a
pageController as a string instead of an instance of a branch delegate.
On May 10, 2012, at 1:55 AM, Ron X wrote:
that was in debug mode.
in run-mode:
WARN 422.22 MB used/87.72 MB free [WorkerThread3]
What VM arguments are you using for:
-XX:MaxPermSize=??? -Xmsm -Xmxm
On May 4, 2012, at 9:58 AM, Ron X wrote:
i have small database - about 50 Mb...
code:
ListPageInterface listPage = D2W.factory().listPageForEntityNamed(
Song.ENTITY_NAME, session());
If you are fetching tens of thousands of rows for a list page, you may want to
consider using the ERXBatchingDisplayGroup to minimize memory usage. By
default, the WODisplayGroup pulls all the EOs into memory. The batching
display group uses the database to handle the pagination. It only
11 matches
Mail list logo
