+Additional Info It's running in file mode and embedded mode.
Regards, On Friday, March 30, 2012 9:12:43 PM UTC+8, Hom L wrote: > > 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/-/YQ_wg65Jdk4J. 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.
