I have a table with 45 columns, almost all INTEGER columns. It has circa 3 million rows. There are three indices plus the primary key index.
TRUNCATE TABLE is extremely slow with this table. Like so slow, I'm afraid my users will think the system is not responding. I did some profiling of the H2 source and found that PageBtreeIndex.truncate(Session session) is at fault. It seems to act as if a normal "DELETE FROM [tablename]" is being performed, deleting each index node individually, via the removeAllRows() method. Do you have any tips for speeding up this usage of the TRUNCATE TABLE command? Regards, Steve McLeod -- 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.
