You could so something like: SELECT binA, binB FROM myTable ORDER BY binA LIMIT 10000
and then store the last binA value you receive and go: SELECT binA, binB FROM myTable WHERE binA > lastBinAValueFromPreviousSelect ORDER BY binA LIMIT 10000 and repeat that until you have processed all the data. Which should be reasonably snappy because it can use the primary index to locate the data efficiently. On 2014-02-05 11:43, Jan Møller wrote:
On startup I wish to read through it all to generate a graph, so basically: read next element, do something, rinse and repeat
-- 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/groups/opt_out.
