Re: database 900 MB slow to open, is it normal?

mikkel.kamst...@gmail.com: 2009/12/7 Sylvain Pointeau sylvain.point...@gmail.com: Hi, I would like to know if this is normal that this is slow (15 seconds) to open a (large?) database (900MB)? I am using the web interface provided in the package. Best regards, Sylvain I have a 22GB

Re: database 900 MB slow to open, is it normal?

, SHUTDOWN); conn.close(); for closing the connection, is it bad? Best regards, Sylvain On Mon, Dec 7, 2009 at 2:21 PM, Sylvain Pointeau sylvain.point...@gmail.com wrote: I will try asap and let you know, my first impression would be that I closed it normally ... but it is probably my mistake

Re: database 900 MB slow to open, is it normal?

Erlandsen mikkel.kamst...@gmail.com wrote: 2009/12/7 Sylvain Pointeau sylvain.point...@gmail.com: Hi, I did what you suggest, opening it with the shell and then quit to properly close the DB. yes it goes faster to open it after that but still it uses 8 seconds. Is this time linear with the db

Re: database 900 MB slow to open, is it normal?

at 9:46 AM, Mikkel Kamstrup Erlandsen mikkel.kamst...@gmail.com wrote: 2009/12/8 Sylvain Pointeau sylvain.point...@gmail.com: for opening the connection I use: Class.forName(org.h2.Driver); Connection conn = DriverManager.getConnection(jdbc:h2:/mydir/myapp/mydb, sa, ); Ok, nothing

Re: database 900 MB slow to open, is it normal?

yes it is a new database it is called .h2.db and I am sure to use the latest one... don't know what happens. Is there something I could test? On Mon, Dec 14, 2009 at 8:52 PM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, now I am sure I am using the latest version, and it is

Re: database 900 MB slow to open, is it normal?

Hi, yes I use a macbook pro: version 10.6.2 processor 2.66 GHz Intel Core 2 Duo Memory 4 GB 1067 MHz DDR3 the SSD is: *APPLE SSD TS256:* Capacity: 251 GB (251,000,193,024 bytes) Model: APPLE SSD TS256 Revision: W010011b Serial Number: 039920002048 Native Command Queuing:

Re: database 900 MB slow to open, is it normal?

did it help? Can I do something more for you? Best regards, Sylvain On Mon, Dec 21, 2009 at 11:10 AM, Sylvain Pointeau sylvain.point...@gmail.com wrote: Hi, yes I use a macbook pro: version 10.6.2 processor 2.66 GHz Intel Core 2 Duo Memory 4 GB 1067 MHz DDR3 the SSD is: *APPLE SSD

Re: JVM to C in 1.2.132?

Hello, I had a different use case of H2, I used H2 because it was required to write my software in java (requested by the customer), but I always wanted to use those data in some other softwares written in C++. Furthermore I planned to rewrite this software in C++ (absolutely required to answer

Re: JVM to C in 1.2.132?

don't worry, Thomas was speaking about a compiler to translate the Java code to the C code, it means that the main branch will stay Java, the C version will just be the result of a compiler. which makes me think that the C version won't (probably) be stable (I hope I am wrong) Best regards,

Re: H2 C Version and LLVM?

if LLVM can be used or contributed, I think this is far the best solution. Best regards, Sylvain On Wed, Mar 24, 2010 at 5:46 AM, Brian iwor...@gmail.com wrote: It looks like there was some initial work on translating java bytecode using the LLVM compiler infrastructure. http://llvm.org/

Re: JVM to C in 1.2.132?

how will you synchronize the different changes? if you do everything from scratch, re-implementing H2, seems to be very hard to maintain in the future. I think it would be much better to automatize the translation to C with a tool like LLVM or whatever. Best regards, Sylvain On Thu, Apr 8, 2010

Re: JVM to C in 1.2.132?

- translator approach. I've dismissed both ideas. What would bring a lot of joy to the world is if there was a C++ compiler that could target the java VM. Unfortunately, as I recall, Sun discourages that sort of thing. On Apr 8, 1:19 am, Sylvain Pointeau sylvain.point...@gmail.com wrote: how

Re: JVM to C in 1.2.132?

Seems interesting, could you point on the issues in sqlite3 and compare them with H2 and how H2 solved them? Best regards, Sylvain On Fri, Apr 9, 2010 at 5:57 AM, James Gregurich bayouben...@mac.com wrote: On Apr 8, 2010, at 8:58 PM, Sylvain Pointeau wrote: You will probably end-up

Re: JVM to C in 1.2.132?

could end up with two sessions thinking they had exclusive access. However, that was in an older version of your code. You may have fixed that by now. I don't know yet. I just refreshed my copy of your repository today after many months. On Apr 8, 2010, at 11:47 PM, Sylvain Pointeau wrote

Re: exception handling code not exception safe

hello, in C++ you can throw object of course, and preferably by copy to avoid new and memory leak. The way of doing it in Java in H2 is good, nothing to change. Best regards, Sylvain On Sat, Apr 17, 2010 at 7:14 PM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I'm not an expert

Re: exception handling code not exception safe

so don't use new in C++, but it is the way to do in Java (everything is reference) On Sat, Apr 17, 2010 at 10:41 PM, James Gregurich bayouben...@mac.comwrote: You didn't understand. converting the exception isn't the issueand you can certainly throw exceptions in catch blocks. The

Re: H2 and rename file extension

what about electric.h2db NaturalGas.h2db etc? On Fri, May 7, 2010 at 9:30 PM, Paluee palme...@gmail.com wrote: Hi there, The reason why I would want to change it is for esthethic reasons, and Human Interaction/Usability reasons. For example, people who use windows expect certain things like

[h2] CSVREAD seems to remove trailing spaces

Dear all, I just noticed that CSVREAD just removes the trailing spaces in the values. is it a bug or done on purpose? Best regards, Sylvain -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails

Re: [h2] CSVREAD seems to remove trailing spaces

On Tue, Aug 4, 2015 at 11:05 AM, Sylvain Pointeau sylvain.point...@gmail.com wrote: On Tue, Aug 4, 2015 at 10:47 AM, Noel Grandin noelgran...@gmail.com wrote: Yeah, we're sorry, but everybody __feels__ like CSVREAD should match their particular use-case, when the reality is that CSV

Re: [h2] CSVREAD seems to remove trailing spaces

=false). Best regards, Sylvain On Tue, Aug 4, 2015 at 7:45 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I think I will keep it as it is. Regards, Thomas On Monday, August 3, 2015, Sylvain Pointeau sylvain.point...@gmail.com wrote: select * from CSVREAD('test.csv','charset

Re: [h2] CSVREAD seems to remove trailing spaces

On Tue, Aug 4, 2015 at 10:47 AM, Noel Grandin noelgran...@gmail.com wrote: Yeah, we're sorry, but everybody __feels__ like CSVREAD should match their particular use-case, when the reality is that CSV is simply not a robustly specified standard. CSVREAD matches my use case, my problem is

Re: [h2] index for OR clause

On Tue, Jul 28, 2015 at 8:53 AM, Noel Grandin noelgran...@gmail.com wrote: Try doing this: select * from TEST where (a = '123' and b = '456' and c='PP') or (a2='1234' and b = '456' and c='PP'); same result explain select * from TEST where (a = '123' and b = '456' and c='PP') or (a2='1234'

[h2] Re: CSVREAD seems to remove trailing spaces

I just noticed that CSVREAD just removes the trailing spaces in the values. more specifically, enclosed values with are fine, space are preserved, but if it is not enclosed then they are trimmed automatically. is there not an option to keep the values as it is? -- You received this message

[h2] Re: CSVREAD seems to remove trailing spaces

select * from CSVREAD('test.csv','charset=UTF-8 preserveWhitespace=true'); for the record, the below statement is correct, the previous one was incorrect. select * from CSVREAD('test.csv', null, 'charset=UTF-8 preserveWhitespace=true'); -- You received this message because you are

Re: [h2] index for OR clause

hello, actually it was in an update, I have 5 fields, each field updated by a lookup in another table. This lookup query had to be done using a OR. I could split the update in 2 so it is now using index. However I think it would be really the best if H2 could manage it. For instance sqlite is

Re: [h2] CSVREAD seems to remove trailing spaces

On Tue, Aug 4, 2015 at 6:20 PM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I see, Wikipedia https://en.wikipedia.org/wiki/Comma-separated_values writes: In some CSV implementations, leading and trailing spaces and tabs are trimmed. This practice is controversial, and does

[h2] index for OR clause

Hello, I would like to know if this is possible to use an index in the following case: select * from TEST where (a = '123' or a2='1234') and b = '456' and c='PP'; given the table: create table TEST ( a varchar(50) NOT NULL, a2 varchar(50) NOT NULL, b varchar(50) NOT NULL, c varchar(50)

Re: [h2] encrypted database with file password

as Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > I'm sorry but I don't really understand the question. It sounds like a > question about application design, maybe you better ask on StackOverflow.com > > Regards, > Thomas > > > On Sun, Jan 17, 2016

[h2] encrypted database with file password

Hello, considering a client app using an encrypted database, using LDAP to authenticate the user, I was wondering if we have another option than to ask the user to enter his user id, windows password and the file password? and what about the "sa" password? I was thinking to change the password

[h2] H2 lucene

Hello, I tried using the native full text search on my db but from 2 GB, it grew up to +12GB, I had to stop the index creation. So I tried Lucene and the database grew up to almost 6GB. Advantage of Lucene is that we can query with wildcards. now my question: why are you still using version

Re: [h2] H2 lucene

can be created, that > would be great. At least I would need to know the database URL, the size of > the database file, the Java version, and the stack trace. > > Regards, > Thomas > > > On Wednesday, March 1, 2017, Sylvain Pointeau <sylvain.point...@gmail.com> > wro

[h2] is it safe to bind a string on a CLOB field

Hello, Do you know if this is safe to bind a string in a clob field? PreparedStatement ps = conn.prepareStatement("update CLOBTABLE SET CLOBFIELD = ?"); ps.setString(1,"my very long string"); ps.executeUpdate(); Thank you, Best regards, Sylvain -- You received this message because you are

[h2] Re: database very slow to shutdown

Hello, apologies, it was not an issue from H2 but I had a thread pool that I forgot to shutdown. Best regards, Sylvain On Mon, Oct 31, 2016 at 9:09 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > Dear all, > > My database is about 800 MB and use a lot of CLOB. &g

[h2] database very slow to shutdown

Dear all, My database is about 800 MB and use a lot of CLOB. It is encrypted and has the option to compress the LOB. I use the latest lib available 1.4.193 When my program closes, the database takes approx 10 seconds to close. I use the h2 connection pool and I verified, I have 0 active

[h2] regex_replace does not work with the 4th parameter argument

Hello, using the last version 1.4.193. the regex_replace does not work with the 4th argument: sql> select regexp_replace('Sylvain','S.?.?','TOTO', 'mni') [2016-11-03 14:09:13] [90008][90008] Invalid value "TOTO" for parameter {1}; SQL statement: select regexp_replace('Sylvain','S.?.?','TOTO',

Re: [h2] Re: regex_replace does not work with the 4th parameter argument

Thank you very much, will you make another release soon with the fix? On Thu, Nov 3, 2016 at 2:38 PM, Evgenij Ryazanov wrote: > It's due to typo in REGEXP_REPLACE implementation. I'll send a pull > request with fix. > > -- > You received this message because you are subscribed

Re: [h2] New version 1.4.194 - performance regression on index creation?

the table definition, a description of the > data (example data would be best), number of rows, and index definition. > > Regards, > Thomas > > > On Monday, March 13, 2017, Sylvain Pointeau <sylvain.point...@gmail.com> > wrote: > >> Dear team, >> &g

[h2] New version 1.4.194 - performance regression on index creation?

Dear team, Is there any performance regression for creating the indexes? I found that my database take ages to create the indexes after mass load. Please let me know. Best regards, Sylvain -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] H2 lucene

if the DB is not reliable anymore... Best regards, Sylvain On Wed, Mar 1, 2017 at 7:46 AM, Thomas Mueller Graf < thomas.tom.muel...@gmail.com> wrote: > Hi, > > Patches to upgrade Lucene are welcome. > > Regards, > Thomas > > > On Tuesday, February 28, 2017, Sylvain Poi

Re: [h2] H2 lucene

Hi Thomas, Additionally I just noticed that FTL_SEARCH(_DATA) returns only 100 records. is it something we can configure? I did not see any information in H2 documentation or google Best regards, Sylvain On Wed, Mar 1, 2017 at 10:58 AM, Sylvain Pointeau < sylvain.point...@gmail.com>

Re: [h2] H2 lucene

Hi Dmitry, Yes thank you it works :-) Do you know if this is reliable to use Lucene in H2? I just had an exception this morning. (from a database created yesterday) [2017-03-01 10:10:41] [HY000][5] General error: "java.lang.IllegalStateException: Chunk 5451 no longer exists [1.4.193/9]"

Re: [h2] Re: MVStore.compactMoveChunks() problem

> > > Unfortunately, we have replaced MVStore in our project as we could not > handle the database file size growth problem even using compactMoveChunks() > method. > > Please could you share a bit more? which library did you use instead? what is your feedback on the H2's replacement? -- You