Discussions
Performance and scalability: Performance hit when creating Entity Beans to insert 8000 rows
-
Performance hit when creating Entity Beans to insert 8000 rows (3 messages)
- Posted by: sheetal P
- Posted on: April 12 2001 15:31 EDT
I am trying to create Entity Beans to insert 8000 rows in the database and facing a major performance problem. It is taking a good 5 minutes to complete the process. We use CMP with Inprise App Server, that's the architecture we have to comply with. Is there anything that I can do to increase the performance by reducing the processing time? Thanks in advance.Threaded Messages (3)
- Performance hit when creating Entity Beans to insert 8000 rows by sheetal P on April 12 2001 15:43 EDT
- Performance hit when creating Entity Beans to insert 8000 rows by Robert Edison on April 20 2001 15:51 EDT
- Performance hit when creating Entity Beans to insert 8000 rows by Rod Johnson on April 27 2001 12:35 EDT
-
Performance hit when creating Entity Beans to insert 8000 rows[ Go to top ]
- Posted by: sheetal P
- Posted on: April 12 2001 15:43 EDT
- in response to sheetal P
sorry, this should have been under the Performance forum.
-sP -
Performance hit when creating Entity Beans to insert 8000 rows[ Go to top ]
- Posted by: Robert Edison
- Posted on: April 20 2001 15:51 EDT
- in response to sheetal P
The problem is that your likely creating 8000 EJBs, one for each row. It might be better to push the row insertion back to the database server by invoking a stored procedure in the EJB. Then only one instance is required. -
Performance hit when creating Entity Beans to insert 8000 rows[ Go to top ]
- Posted by: Rod Johnson
- Posted on: April 27 2001 12:35 EDT
- in response to sheetal P
Entity beans are a nice abstraction, but I fear you've hit one of the situations in which they simply have too much overhead. I would use JDBC in a session bean to do the update: this way your server won't need to create 8000 objects.