Hi, > If this is csvread problem
Actually, the problem is insert, update, and delete. > - there was no index nor primary key on the table Too bad. If you have a primarky key or unique index, it would most likely work (at least the limit would be higher). The problem is that H2 keeps the undo log for one operation in memory. See also http://www.h2database.com/html/grammar.html#setmaxmemoryundo "Changes to tables without a primary key can not be buffered to disk." But still CREATE TABLE ... AS SELECT * FROM CSVREAD(...) is faster (because it doesn't need an undo log at all). > truncate table H2 support that too. 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 -~----------~----~----~----~------~----~------~--~---
