Re: [h2] H2: problem with space re-using + minimal example

2013-10-17 Thread alexander . bereskin
Hi, these are great news! Can you say something about the lobInDatabase option? Is it really not going to be supported in the future? Am Mittwoch, 16. Oktober 2013 14:49:07 UTC+2 schrieb Noel Grandin: On 2013-10-16 13:37, alexander...@gmail.com javascript: wrote: we are experiencing the

[h2] alternatives to support multi-tenancy in DB

2013-10-17 Thread aditya
Hi, As a part of providing multi-tenancy support to our application, I was looking for alternatives for enhancing the current H2 database for the same. Couple of options that I was thinking were: 1. same database, different schema (one schema per tenant) 2. different DB instance per tenant

[h2] Re: alternatives to support multi-tenancy in DB

2013-10-17 Thread aditya
Correction on the statistics: Data size per tenant could be somewhere around 35 MB (under load) and around 25000 records in a couple of tables. Other tables (around 15 in all) will have very less amount of data comparatively and there are no BLOB/CLOB type of columns in the database. On

[h2] How to enforce CSV column order with INSERT INTO / CSVREAD command

2013-10-17 Thread Tuomas Kiviaho
Hi, INSERT INTO foobar SELECT * FROM CSVREAD('foobar.csv') tries to insert values from CSV rows to wrong table columns when table and CSV column order doesn't match. CSV has the column header row and it seems to be interpreted at Function#getValueForColumnList INSERT INTO foobar (foo, bar)

Re: [h2] How to enforce CSV column order with INSERT INTO / CSVREAD command

2013-10-17 Thread christoff . schmitz
Hi, In my project we use H2 table functions to read data from other databases. I found out that H2 calls our table functions more often than expected, which can lead to serious performance problems if the execution of the SQL from the other database is quite expensive. The sample code below

[h2] Tablefunctions called too often

2013-10-17 Thread christoff . schmitz
Hi, In my project we use H2 table functions to read data from other databases. I found out that H2 calls our table functions more often than expected, which can lead to serious performance problems if the execution of the SQL from the other database is quite expensive. The sample code below