Re: [eclipselink-users] Slow Mapping
i've enabled FINEST logging and additional messages has added:
FINEST Register the existing object 50006000
this registry is added per each Object. does this mean is caching the
object in every query?
no more native queries has been executed.
On Tue, Feb 9, 2010 at 9:50 AM, James Sutherland <jamesssss@xxxxxxxxx> wrote:
> 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://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
> EclipseLink , http://www.oracle.com/technology/products/ias/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.
> eclipselink-users mailing list
GNU/Linux User #443701