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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
18 matches
Mail list logo