[h2] Re: Database size explodes when exporting to SQL

2018-06-15 Thread Silvio
Thank you for the response Evgenij, The databases are quite flat. No CLOB/BLOBs, foreign keys or anything fancy etc. They do contain a couple of dozens of tables with up to a couple of dozen columns. And some of the tables may contain up to 50K rows. In PageStore and newly created MVStore

[h2] Re: Database size explodes when exporting to SQL

2018-06-15 Thread Evgenij Ryazanov
Hello. I can't reproduce such issue with SCRIPT, SCRIPT TO, or BACKUP commands with large database and different settings. May be your database schema contains something special. You can try to create a some standalone test case for this issue and share it with us. H2 had a long-standing

[h2] Re: Database size explodes when exporting to SQL

2018-06-15 Thread Silvio
I made one additional observation which is quite puzzling. The increase in database size happens asynchronously. At the moment the SQL script has been written (and the connection that was used to issue the "SCRIPT" command has been closed) the database is only partially inflated. Some

[h2] Re: Database size explodes when exporting to SQL

2018-06-14 Thread Silvio
Besides primay keys that would be zero. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send

[h2] Re: Database size explodes when exporting to SQL

2018-06-14 Thread Christian MICHON
Hi, how many indexes do you have inside your database? On Thursday, June 14, 2018 at 1:24:34 PM UTC+2, Silvio wrote: > > I tried connecting to the database from the H2 query tool and executing > "script". Same thing happens there. > -- You received this message because you are subscribed to

[h2] Re: Database size explodes when exporting to SQL

2018-06-14 Thread Silvio
I tried connecting to the database from the H2 query tool and executing "script". Same thing happens there. -- 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