Hi, Nice thank you !
We will give you more feedback later about the beta version of h2. Regards, Nicolas Fortin Atelier SIG, IRSTV FR CNRS 2488 http://github.com/nicolas-f Le mercredi 3 septembre 2014 07:44:58 UTC+2, Thomas Mueller a écrit : > > 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] <javascript:>> 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]. 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.
