id « Performance « JPA Q&A

1. Fastest way of checking if one (or more) entries with given id is present in several tables stackoverflow.com

In my application DB, for a given Foo Object with a String id, there are seven tables, each one contains information about Foo Object, and each of the 7 tables has ...

2. Performance issue: too many id is set t0 "in" quer forum.hibernate.org

3. Oracle id generation performance forum.hibernate.org

Hello! I'm using hibernate 3.0.5 with oracle and "sequence" id generator. Everything works fine except one thing. Under heavy load (really heavy, many inserts, updates) i have sequence locking. Have to enable Oracle sequence cache to avoid this. I see 3 possible id generation strategies in my case: 1) using "sequence" (just as i do now) 2) using "seqhilo" - never ...

4. Assigned id - Performance Question forum.hibernate.org

This is my current solution: Code: Session session = HibernateSessionFactory.getSession(); Item item = new Item(); Integer itemNo = (Integer) session.createSQLQuery("select NextID from temp").list().get(0); String year = "07"; // TODO: hardcoded ...

5. Id choice and SELECT before INSERT performance forum.hibernate.org

Hi there. I'm using hibernate; my classes all use a generated UUID type, so the Id is generated on the client (not the database). I've got ClassA (many-to-one) ClassB. When I do a session.save(classA), what I'm seeing is a SELECT for the Id of classB, which really slows things down with heavy imports. (and I do session.save(classB) later on anyway. Tracing ...