I seem to be running into a memory issue when using offsets. I get "java.lang.OutOfMemoryError: Java heap space" when I try to do the following:
select customer_id, book_id, date, rating from training.ratings limit 1 offset 100000 There are about a million rows in the table. Sometimes it takes a few "probes" of various offsets before it barfs. My table looks like the following: create schema training create table training.customers (id int primary key); create table training.books (id int primary key, name varchar, date date); create table training.ratings (customer_id int not null, book_id int not null, date date not null, rating real, primary key (customer_id, book_id)); Is it trying to read all the rows into the ResultSet before "scrolling" to the offset? If it's helpful, I'll try to cook up a unit test for this. Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
