Hi, >>> Ordering is slow for large results > Unfortunately, I use the query for UI related matters that users > expect to be instantaneous. Currently it can take up to a couple of > seconds, which users perceive as very slow.
Usually, the user doesn't expect _large_ results to appear instantaneous. Instead, GUIs tend to only display one page at a time (for example, the Google results page). > Do you plan to improve h2 to be able to take advantage of the existing > indexes in order to accelerate the described query substantially? No, I'm sorry, I don't plan to implement this feature currently. If you want to do it, please go ahead. If you want to send a patch, please see http://www.h2database.com/html/build.html#providing_patches Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
