Hi, At some point, server side cursors will be implemented, then you will just have to run "select * from tableName" and you are done. This will require some changes however; it can not be supported when using the PageStore. I expect it will take a while until this is available.
we are caching _ROWID_ or primary keys if available, then query a batch of > rows using the keys in the where clause. > That's what I would do as well. This is quite slow as the query condition has to be evaluated by the h2 > engine. > Are you sure the bottleneck is evaluating the condition? That's weird. How did you test it? Do you have a simple test case? It might be slightly faster to use some internal API, depending on what you want to do with the data. For example, "create table ... as select" uses a direct API that doesn't buffer rows. Possibly even faster would be to access the MVStore directly (if the data is stored there). But such solutions are harder to maintain, and might not help all that much. Regards, Thomas -- 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.
