Hi,
Using H2 1.4.181 (2014-08-06):
Creating a huge table (118mb):
<raw>
create table mytable as select
REPEAT(hash('SHA256',STRINGTOUTF8((rand()+X)::varchar),1),2) field from
SYSTEM_RANGE(1, 400000);
</raw>
Then request only one row using _ROWID_
<raw>
select * from MYTABLE where _ROWID_ = 1
</raw>
It took 437 ms
It seems that MVStore check all row, and is not using internal storage index as
claimed in documentation.
Our software OrbisGIS use this row identifier in order to speed-up the
rendering of the table when Pk is not available.
Can you speed-up the _ROWID_ column query with mvstore, as it is with regular
table ?
Thanks for reading
Regards,
-Nicolas Fortin
Atelier SIG, IRSTV FR CNRS 2488
http://github.com/nicolas-f
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
