search

Tmr / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

system column _ROWID_ slow with MVSTORE #579

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Using H2 1.4.181 (2014-08-06):

Creating a huge table (118mb):

create table mytable as select 
REPEAT(hash('SHA256',STRINGTOUTF8((rand()+X)::varchar),1),2) field from 
SYSTEM_RANGE(1, 400000);

Then request only one row using _ROWID_

select * from MYTABLE where _ROWID_ = 1

It took 437 ms

It seems that H2 check all row, and is not using internal storage index as 
claimed in documentation.

Original issue reported on code.google.com by nico.de...@gmail.com on 28 Aug 2014 at 2:40

GoogleCodeExporter commented 9 years ago 
Nice done, 3ms now. And our software OrbisGIS seems to be responsive now with 
h2 mvstore.

Thank you.

You can close this issue.

Original comment by nico.de...@gmail.com on 5 Sep 2014 at 7:12

GoogleCodeExporter commented 9 years ago 
OK, thanks for reporting and for verifying!

Original comment by thomas.t...@gmail.com on 5 Sep 2014 at 12:37