Hi, Thanks for the patch Thomas. I will test it as soon as the snapshot build will be available.
-Nicolas Le mercredi 3 septembre 2014 10:16:21 UTC+2, Nicolas Fortin (OrbisGIS) a écrit : > > 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]> 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.
