On May 7, 5:14 am, beaTunes Support <[email protected]> wrote: > On May 6, 2009, at 23:35 , Brish wrote: > Yes, Brish, for moving back and forth that would be good. > But unfortunately the initial query still takes a very long time with > h2.
Most databases can iterate over results so they can return the first few results immediately regardless of the result set size if the result set isn't ordered or if the order can be resolved by an index. H2 runs the entire query then returns the results which causes all large queries to be slow. Maybe you should request cursors in h2 so that you can navigate a large result set. fyi Cursors is a major feature which would likely require a lot of h2 to be rewritten. Brish --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
