[h2] full text lucene phrases search.

Is there way to search for phrases with full text search in h2 I configured lucene according to documentation and all works fine for words search fut when I try to search for exact phrase , words separated by space in quotes it ignores it and still return separate terms based result not phrases

[h2] insertion after drop is much slower than insertion in a new Table

Hello, I am inserting (with batch insert - bulk=1) around 350,000 rows in a table, when the table (and File DB) does not exist the load is very fast, then I rerun the test which drop the table before (if exists) then commit then recreate the table, the insertion then is very slow and there

[h2] H2 SCRIPT without filename still uses a fie to return the result set

Hi, I have used the SCRIPT command to generate e database table script in our application. As I do not want to write to a file for security reasons and do not want to handle file deletion permission issues, I did not specify the file name and used the result set in the application. Today there

Re: [h2] H2 SCRIPT without filename still uses a fie to return the result set

Can you post the full stack trace? Today there was an IO Exception saying FIleNotFound for the script file. It means H2 internally still uses a file in a physical location to generate the result set. This is not mentioned in H2 site. Is this correct? -- You received this message because you

Re: [h2] Trigger: ALTER statements failing - Commit or rollback is not allowed

Yeah, sorry, our architecture doesn't allow that at the moment. At some point in the future we should be capable of opening connections inside triggers and performing commits using our new MVStore engine. However, I can't see that performing DDL inside a trigger is ever going to work. The onl

Re: [h2] insertion after drop is much slower than insertion in a new Table

Could you try using the H2 profiler to see where the time is going: http://h2database.com/html/performance.html#application_profiling ?? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails fr

Re: [h2] insertion after drop is much slower than insertion in a new Table

I rerun the test with trace_level=2, with level=3 the file was extremely big but if needed, I can try to do that also with another set of data, but my results with trace_level 2 is: First Run, the database does not yet exist: - -- SQL Statement Statistics

Re: [h2] insertion after drop is much slower than insertion in a new Table

Hi Could you try using our simple profiler on the second run, like this: import org.h2.util; ... Profiler profiler = new Profiler(); profiler.startCollecting(); // application code System.out.println(profiler.getTop(3)); It should show us where the time is being spent inside the H2

Re: [h2] insertion after drop is much slower than insertion in a new Table

I did this, I replaced application code with statement.executeBatch() // which should insert 10,000 inserts at once, the result is this: H2: Profiler: top 3 stack trace(s) of of 254 ms of 127 thread dumps: 120/126 (95%): at org.h2.store.fs.FileDisk.force(FilePathDisk.java:410) at org.h2.store.Fil

Re: [h2] H2 SCRIPT without filename still uses a fie to return the result set

Hi Noel, This is the error log... You can see that I have not given any filename and just left it as empty (''). H2 is trying to write to script.sql and throws "access is denied" exception... SCRIPT NOPASSWORDS NOSETTINGS DROP TO '' TABLE *TABLE_NAME* [90028-175]; nested exception is org.h2.jd

Re: [h2] insertion after drop is much slower than insertion in a new Table

It looks like it is spending all of it's time getting new sequence values. Try modifying the CACHE_SIZE attribute on your sequence values and your IDENTITY columns. The default value is 32, which is probably way too small for you. On 2014-04-07 15:35, Kais Haddadin wrote: H2: Profiler: top 3 s

Re: [h2] H2 SCRIPT without filename still uses a fie to return the result set

I think you are misreading the documentation. If you want it to return it a ResultSet, you need to omit the "TO" section of the command. So your command should look like: SCRIPT NOPASSWORDS NOSETTINGS DROP TABLE On 2014-04-07 15:56, Chandra DhulipalaV wrote: This is the error log... Y

Re: [h2] insertion after drop is much slower than insertion in a new Table

what do you mean by changing the cache for the IDENTITY column, is this the same as changing the cache for the sequence? the only way for this is to update all sequence in a INFORMATION_SCHEMA.SEQUENCES table to use different cache value. I want to avoid that if possible. On Mon, Apr 7, 2014 at 4

Re: [h2] insertion after drop is much slower than insertion in a new Table

thinking about this again I don't understand why this should make a difference if the table is already there or not, if 32 is a small value then it should be slow when I insert the 366328 in the first run as well, right? Cheers, Kais On Mon, Apr 7, 2014 at 4:29 PM, Kais Haddadin wrote: > what

Re: [h2] H2 SCRIPT without filename still uses a fie to return the result set

That worked... somehow I missed to try that... Thanks a lot... On Monday, April 7, 2014 3:12:35 PM UTC+1, Noel Grandin wrote: > > > I think you are misreading the documentation. > > If you want it to return it a ResultSet, you need to omit the "TO" section > of the command. > > So your comman

[h2] Re: insertion after drop is much slower than insertion in a new Table

Are you able to put together a simple example that shows the problem (script to create table, java app that connects to thhe database and does the inserting)? The profiler output shows the problems of people having to ask you to do tests - all the results show is that the problem is within the

[h2] cant get CSVREADER to work ok

have a CSV file with entries like Jim Sample,"3 Sample Street, Sampleville, Australia. 2615",j...@sample.com some quoted, some not when i do create table tabla(nom varchar(255), dir varchar(255), mail varchar(255)) AS SELECT * FROM CSVREAD('E:\\TESIS\\modulocarga\\addresses.csv')"; every fiel

Re: [h2] Re: insertion after drop is much slower than insertion in a new Table

It will take some time to do that I will try to do that as soon as possible and post it here. Cheers, Kais -- 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 h2-da