Re: [h2] lots of schemes vs lot of tables?

Ok, thank you very much Thomas.Thanks,Josh

Re: [h2] lots of schemes vs lot of tables?

Hi, > I keep getting emails from this thread Well, this is a mailing list, and you have subscribed to it. No problem, I will unsubscribe you. Anyway it will be easier for you to use StackOverflow and not this mailing list. Regards, Thomas On Sat, Sep 21, 2013 at 9:53 PM, Gmail - Josh wrote:

Re: [h2] lots of schemes vs lot of tables?

Hi Thomas,I keep getting emails from this thread, so I assumed it was the one I posted, I did not mean to hijack any thread. Just the topic is a matter of urgency as it is my grade 11 final project due next week friday and I cannot get the database working.I have answered on the thread.Thanks for y

Re: [h2] lots of schemes vs lot of tables?

Hi Josh, Your question is not related to the subject of this thread, which is "lots of schemes vs lot of tables?". Please don't try to hijack other threads. Also, it seems to me you have asked this question here: http://stackoverflow.com/questions/18924873/h2-embedded-database-loses-tables-data-o

Re: [h2] lots of schemes vs lot of tables?

Hi guys, so I have only 1 table called table1 in the database, but when I transfer the h2.jar file over to another pc (exported as a file along with all the other .jars in the project) and then the table is gone on the new pc. How do I get it to stay? Thanks, Josh On Sat, Sep 21, 2013 at 9:34

Re: [h2] lots of schemes vs lot of tables?

Hi, schema and table metadata is kept fully in memory I see the problem. For instance, how much memory would require (approximately) 10.000 schemes x 10 tables = 110.000 object medata? Would that magnitude order be of Megas or Gigas? Megas might be acceptable. Gigas, hmm... Regards, Pablo. 201

[h2] packaging a database for deployment

Hi there, I need a step by step instructions on how to get a database to be deployed with an application when it installs. I have looked at the h2 database engine but cannot figure it out, I am new to java, and database integration. This is my process so far: 1 - Add external Jar file for h2

Re: [h2] MVStore question

Thomas, The keys are (theoretically) added in ascending order. But there could be a few occurrence of out of order keys. I will try your suggestions and let you know how it pans out. Thanks again for all your work on H2 (and Noel's as well :-) ) On Saturday, September 21, 2013 2:04:50 PM UTC-

Re: [h2] MVStore question

Hi, > MVStore (version 1.3.172) It is changing quite quickly, I suggest to use the latest version (1.3.173, or even better, the latest automated build at http://h2database.com/html/download.html (direct link: http://www.h2database.com/automated/h2-latest.jar ) > I simply use a Map where key and

Re: [h2] performance differences in insert commands

I suspect the "insert into..." behavior is affected by indexes in a way that looping over "insert" is not. Could this be a buffer issue of some kind, like "insert into..." treats the entire operation as one, while a loop over "insert" is treated as a bunch of smaller operations? If I create the

[h2] MVStore question

Hello, I am testing the use the MVStore tool standalone. (version 1.3.172) My use case is simple. I just want to check if a string sequence read from my application has already been seen previously. I simply use a Map where key and values are equal (since null values are not permitted). And w

Re: [h2] showing tuning parameters

Hi, Yes: SELECT * FROM INFORMATION_SCHEMA.SETTINGS Regards, Thomas On Sat, Sep 21, 2013 at 4:36 AM, Brian Craft wrote: > Is there a way to show the current values of the various tuning > parameters, like cache_size? > > -- > You received this message because you are subscribed to the Google

Re: [h2] lots of schemes vs lot of tables?

Hi, You are right of course. The problem I see is that you might end up with a lot of schemas and a lot of tables, if you try to keep all data in one database. For H2, schema and table metadata is kept fully in memory, I'm not sure about other database engines. And at some point you might want to

Re: [h2] H2 Embedded Database loses tables / data on deploymen

Hi, Please don't double post. You have asked this question also at http://stackoverflow.com/questions/18924873/h2-embedded-database-loses-tables-data-on-deploymen Regards, Thomas On Fri, Sep 20, 2013 at 9:59 PM, Josh Harington wrote: > Hi Guys, > > So I have an application, and it uses a datab

[h2] H2 Embedded Database loses tables / data on deploymen

Hi Guys, So I have an application, and it uses a database, now I need to use an embedded database inside the application so that all you do with it is install the program, and the database is already there (So the client does not have to install a copy of mysql server, wamp, xampp, etc to run t

Re: [h2] lots of schemes vs lot of tables?

Hi Thomas, You are right, many schemas implies many tables. What I like of the may schemas approach (one per user) is that I can partition the data very neatly and resolve the data isolation simply with the connection: public Connection getConnection(String userId){ Connection conn = pool.ge