Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Ive tried inserting many objects and find that it is slow. What is going on ?

April 26, 2017going inserting objects slow

0

Posted

Ive tried inserting many objects and find that it is slow. What is going on ?

1 Answer

0

Posted

You are likely using the MaxPoidGenerator to create the identity for the new objects. This makes a database call to get the next available id. This is the default because it works on ALL RDBMS. We recommend that you replace this with an AutoIncrement or Sequence based identity generator depending on your RDBMS. Please see the Identity Generation Guide for details of these and how to select them in your Meta-Data. The SequenceTablePoidGenerator is recommended since it will work on all databases.