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: 2012/5/10 Johann Werner <j...@oyosys.de> > 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 1 370 393 487M+ 9124K 525M+ > > RuntimeException: Statement running too long > at > er.extensions.eof.ERXEOAccessUtilities.logExpression(ERXEOAccessUtilities.java:1213) > at > er.extensions.eof.ERXAdaptorChannelDelegate.adaptorChannelDidEvaluateExpression(ERXAdaptorChannelDelegate.java:81) > ... skipped 5 stack elements > at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223) > at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:163) > ... skipped 6 stack elements > at > er.extensions.eof.ERXDatabaseContext._objectsWithFetchSpecificationEditingContext(ERXDatabaseContext.java:66) > ... skipped 1 stack elements > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) > at > com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069) > at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1302) > ... skipped 1 stack elements > at > com.legalsounds.MainNavigationController.mostDownloadedAction(MainNavigationController.java:77) > ... skipped 15 stack elements > at > er.extensions.appserver.navigation.ERXNavigationMenuItem.menuItemSelected(ERXNavigationMenuItem.java:137) > ... skipped 64 stack elements > at > er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:157) > at > er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235) > at > er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268) > at > er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302) > at > er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:374) > ... skipped 6 stack elements > > 2012/5/10 Johann Werner <j...@oyosys.de> > >> -Xms512m -Xmx1024m > > > > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com