I am newbie to JPA and OpenJPA and have couple of questions on the best practices in using JPA and OpenJPA and any performance tips while using JPA/OpenJPA.
Here is our application requirement. Basically ours is web based j2ee application that uses JSF,Spring,OpenJPA and DB2 database. We'll dealing with lot of data and that means at a single point of time we'll working(adding, updating, deleting using UI) with min. 100,000+ records in the database. For example, 20-30 users simultaneously will be using our web based application and its UI for inserting 100,000 records into the database, editing 100,000 records in the database, querying the 400,000 records in the database tables etc. These are just few of our application requirements to demonstrate the volume of data will be dealing at a single point of time. Based on aforementioned application requirements, I need inputs from you, the JPA experts, A. what are the best practices while using JPA and OpenJPA? B. what are the various JPA/OpenJPA tips for building the high performance JPA based applications? C. for example, for performance reasons is it good to use, for a table defined in DB2, we have using DB2 IDENTITY COLUMN for primary keys and rather than using in JPA @GeneratedValue(strategy=GenerationType.IDENTITY) instead of @GeneratedValue(strategy=GenerationType.SEQUENCE) or @GeneratedValue(strategy=GenerationType.TABLE) ? Thank you in advance for yout time and reply.
