While trying to debug some performance issues, we narrowed down the problem to calls to Entity Beans taking long time. Original design is nice and generic but does not scale up in this case.
Here are the details:
- J2EE application.
- Oracle DB
- Entity Beans used for DB access.
While creating 50000 instances of a particular entity in DB, performance is terrible because of 50000 calls to bean.create().
Could someone point me some solutions? Here are a few we thought of:
- Create SQL in a text file and then execute it.
- Create a csv file and import it.