Re: [h2] TableEngine DBase

2013-07-30 Thread Nicolas Fortin (OrbisGIS)
Yes. That's a good idea. My idea was, if the files are small, then the duplication wouldn't be such a big problem. How large are the files in general? It can also be related to data management. Those files size are from hundreds of kilobytes to hundred of megabytes, but some applications

Re: [h2] Proposal: Trigger2 Interface

2013-07-30 Thread Thomas Mueller
Hi, In your test case, you didn't actually *execute* the statement. So it was prepare a statement versus do nothing I think a more realistic use case is: (a) prepare, bind the values, and execute a simple statement, versus (b) just bind the values and execute it. Regards, Thomas On Mon,

[h2] H2 restart functionality

2013-07-30 Thread Subhash Agrawal
Hi All, We have a H2 restart functionality which first calls org.h2.tools.Server.stop() function to stop H2 database and then start h2 database using Server.createTcpServer(svrArgs).start(); After starting H2, we create schema and load data into it. There is no delay/sleep between stop and