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 at http://groups.google.com/group/h2-database?hl=en.
