Re: [eclipselink-users] Slow Mapping

[James Sutherland <jamesssss@xxxxxxxxx>]

To start with I would set logging to finest so you can check what is
occurring.  Ensure that the original query is not triggering other queries
for related objects, (this may occur if LAZY is not working because weaving
is not being used in your production server).

You could also try enabling the EclipseLink profiler, or use a third party
profiler such as JProfiler.

You could also simplify the query to determine which part of it is causing
the issue.


John Arevalo wrote:
> 
> Hi list,
> 
> Now i'm facing a problem while load a query:
> 
> i've enabled logging.level to FINE in order to check Native Query,
> executed from jdbc tool takes around 0,031 s.
> 
> i've loaded that ResultList in a h:selectOneMenu(JSF).
> 
> In develop environment works succesfully, but in prod Environment
> takes around 15 seg. 200 objects are Mapped (aprx.).
> 
> no matter how many concurrent users are in the application, the
> response time is the same.
> 
> what can i do to reduce that time?
> 
> Thanks for your replies
> 
> -- 
> John Arévalo
> GNU/Linux User #443701
> http://counter.li.org/
> 
> 


-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://old.nabble.com/Slow-Mapping-tp27503775p27516378.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.