Hi, I have created a H2 table with an index of several fields and loaded 2 million records (the data file grows to 600 MB). When I tried to delete those data with the key, it takes about 5 minutes to do so.
I have already set the LOCK MODE as 0. Is there any way to improve the performance. Regards, -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/dovzhjPIkRAJ. 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.
