As I said I was able to avoid the issue, but figured a h2 db developer might want to know there is an issue.
I think an UPDATE should not increase the filesize by 10x or the behaviour should at least be documented, I think. On Sunday 17 March 2024 at 14:13:36 UTC+7 Andreas Reichel wrote: > Greetings! > > Please try to either a) partitioning you update into smaller > chunks/commits or b) use a CTAS instead (although I am not a big fan of > this). > Good luck > > Andreas > > > On Sat, 2024-03-16 at 22:11 -0700, Alexander Kainz wrote: > > Hi, > > I wanted to mention this issue that took me a while to identify. > > Here's the output from my test code (https://github.com/akainz/h2db) > > Table created successfully.12 KB > Rows inserted successfully. File 986 MB actual data 983 MB > Rows updated successfully.* 9 GB* > > the code sets up a table, then inserts 100K rows and the does an > UPDATE sample_table SET COUNT = 0 > and the db file just 10x's in size. > > That seems to be excessive and forced me to stop updating all rows, maybe > you want to look into it. > > Alex > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/h2-database/91a34196-107b-4fc7-860b-0cc9c3ce523dn%40googlegroups.com > > <https://groups.google.com/d/msgid/h2-database/91a34196-107b-4fc7-860b-0cc9c3ce523dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e8642d26-9e3c-4d41-af65-68b02839f17fn%40googlegroups.com.
