Hi I have this environment: JVM 1.6.0_26 H2-1.3.158
I have a table with 3 million of records inside; by doing this query: SELECT * FROM myTable ORDER BY RECIVEDATE DESC LIMIT 0,15 the database answers to me after more then 3 minutes.....Do you know how i can improve performnances? I created and Index on recivedate field. Cheers, Angelo -- 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.
