Hi, > I have this in a transaction > The best course of action is to find a way to split it into multiple > transactions
I would also split this task into multiple database transactions. See also http://en.wikipedia.org/wiki/Long-running_transaction > making sure I let my app sleep for a few seconds between each import > to give the database a chance to build the indexes The H2 database doesn't build indexes in a background thread. I don't think sleeping a few seconds will help. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
