Hi I have a H2 database which saves around 760MB/day. Yesterday, database size was around 45,542,743.00 KB (approximated). Then, while performing the following query, the database literally exploded:
"SELECT a, b FROM t1 WHERE a NOT IN ((SELECT a FROM t2) UNION (SELECT a FROM t3 WHERE c = ?)) ORDER BY b ASC LIMIT ?;" (There are unique and non-unique inidces on a in every table and an index on c in t3. I am pretty sure this is not the most efficient query, but it was good enough for our purposes ... until now). While performing the above query, the database increased in size with approx. 20MB/s until the disks were full. Currently, that is 89GB and 130GB respectively for the main and the backup server (the same thing happened on the redundant backup server at the same time). I have analyzed the database content, but I cannot see where the 20MB/s of data came from? -- 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/-/r3q3tNlWo_MJ. 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.
