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 ...

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 ...