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: null - > "Song"@116895853 expression took 16567 ms:
If the fetch takes nearly 17s instead of 0.8s there must be something wrong (or at least different). What is the exact SQL that is sent to the db, you should look at that, perhaps something in your model is wrong? > > 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