are you using an index?
and what does the create table and delete statement look like?
On 2012-03-30 15:12, 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/-/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.
--
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.
