Hi, Yes, this is possible. It looks like there is no special test case for this feature, that's why it's not yet implemented for the MVStore. I will fix that.
Regards, Thomas On Tuesday, September 2, 2014, Nicolas Fortin (OrbisGIS) < [email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
