Hi Thomas, Thanks for sorting this out so quickly!
Regards, Steve On Apr 17, 7:26 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > The problem is: the database has to add DISTINCT in the inner query > because values within IN(..) are supposed to be unique. So the inner > query is something like: > > SELECT distinct gameid, starttime FROM test ORDER BY starttime DESC LIMIT 10; > > ...which is very slow currently: it reads all rows from this table, > does a distinct, and picks the first 10. > > This problem will be fixed in the next release. That means the above > query will be fast, and your query will be fast again. > > 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 > athttp://groups.google.com/group/h2-database?hl=en. -- 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.
