0 Replies Latest reply on May 5, 2007 6:02 AM by toni

    Performance issues with batch insert

    toni

      Hi,

      in our webapplication the user can trigger a batch insert, which will create about 400 entities. This takes about 40 minutes.

      In the beginning each entity gets created within a second. The more entities are inserted and the further the process progreses, the slower it gets.

      In the end it takes about 7 seconds to create one and this trend seems to continue. I'm currently running a test to insert a few thousand entities to see what happens.

      First I thought that this might be because of some imperformant SELECT statements of mine. There is lots of business logic involved in creating a single entity with all it's relationships.

      However, if after a batch insert has been completed successfully I start another one, then the same thing happens over. Considerably fast in the beginning and the slowly slowing down.

      If it would be about the tables growing larger, then the second batch insert should be slow from the very start.

      Does anybody know what could be the cause of this?