Re: [h2] out of memory with big db

2015-06-01 Thread Noel Grandin
Which version are you using? If you have 6000 tables, you have something wrong with your database design. -- 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

Re: [h2] out of memory with big db

2015-06-01 Thread naseh
version 1.4.187 i have designed the DB to have a table for every book. maybe it is not a good design but it is easier for me for now at least. On Monday, June 1, 2015 at 11:30:33 AM UTC+4, Noel Grandin wrote: Which version are you using? If you have 6000 tables, you have something wrong

Re: [h2] out of memory with big db

2015-06-01 Thread Thomas Mueller
Hi, I'm sorry, but H2 does not work well if you have thousands of tables. Regards, Thomas On Tuesday, June 2, 2015, Ryan How r...@bitworks.com.au wrote: Maybe you are better off with a different database for each book, and open and close them 1 at a time? It really depends on your

Re: [h2] out of memory with big db

2015-06-01 Thread Ryan How
Maybe you are better off with a different database for each book, and open and close them 1 at a time? It really depends on your application... On 1/06/2015 9:23 PM, naseh wrote: version 1.4.187 i have designed the DB to have a table for every book. maybe it is not a good design but it is

[h2] out of memory with big db

2015-05-29 Thread naseh
Hi, I have dB of 18 GB. opening it is very slow and throw out of memory even before calling the first statement. it stuck while creating the first connection (DriverManager.getConnection). I'm using 256 M of memory. is this something normal. I can understand it is big db but will it stuck