From: <glassfish_at_javadesktop.org>
Date: Fri, 30 Jan 2009 07:09:03 PST

I was able to reproduce this by using a simple entity:

package com.sun.gtee.entity;

import java.io.Serializable;
import javax.persistence.*;

/**
*/
@Entity
public class SlowAttribute implements Serializable
{
   private static final long serialVersionUID = 1L;
   @Id
   @GeneratedValue(strategy = GenerationType.AUTO)
   private Long id;
}

and a
SELECT a FROM SlowAttribute a
TLE query.

I inserted 10000 of these via sql produced by

for i in {0,1,2,3,4,5,6,7,8,9}{0,1,2,3,4,5,6,7,8,9}{0,1,2,3,4,5,6,7,8,9}{0,1,2,3,4,5,6,7,8,9} ; do echo "INSERT INTO SLOWATTRIBUTE (id) VALUES ($i);"; done > slowid.sql

With the old TLE the query takes less than 1 sec (150ms),
but with the new one it takes 13secs or more.

Again
asadmin set "server.log-service.module-log-levels.property.oracle\.toplink\.essentials"=FINER
reports some huge pause in the log.
[Message sent by forum member 'nzinoviev' (nzinoviev)]

http://forums.java.net/jive/thread.jspa?messageID=329230