On Wednesday, February 5, 2014 11:04:15 AM UTC+1, Noel Grandin wrote: > > 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. > > There is a caveat. There is an index on binB, but it is not unique, so I am afraid that I won't get the right result.
-- 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.
