Hi, We are looking for an effective (fast and minimum memory usage) way to retrieve the data from a large table in H2 1.4.X
What we have done so far: In order to not reach the fatal MaxMemoryRows we are caching _ROWID_ or primary keys if available, then query a batch of rows using the keys in the where clause. This is quite slow as the query condition has to be evaluated by the h2 engine. Do you have any better idea ? Thanks, Regards, -- Nicolas Fortin IRSTV FR CNRS 2488 GIS http://orbisgis.org Spatial DB http://h2gis.org Noise http://noisemap.orbisgis.org -- 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.
