Hi, Try to use hash index on a single column with the most unique values (of course this column should be in where clause). But better use profiler and find where h2 spends time. Also may be you should use your own data structures instead of database if it is possible in your case.
regards, Sergi On 15 фев, 16:21, suresh kumar <[email protected]> wrote: > Panayiotis Vlissidis, > > I am using prepared statements, even I tried with batch updates (with > statement, couldn't use prepared statement in batch updates). > The difference in db size after adding multi-column index is 1 KB. > > Thanks, > Suresh > > On Tue, Feb 15, 2011 at 2:04 PM, Panayiotis Vlissidis > <[email protected]>wrote: > > > Hello, > > > Thanks for the update and nice to know it worked. > > Sorry to hear that it's still above 1 sec, maybe someone else > > can provide more suggestions. > > > You should also have a look here: > >http://www.h2database.com/html/performance.html#database_performance_... > > > The easiest things to start with(in case you are not already using them) > > are: > > 1. Use PreparedStatements > > 2. Use batch inserts/updates (PreparedStatement.addBatch()/executeBatch() ) > > > It would also be interesting to know how much the size of the db has > > changed > > after adding the indexes, if you care to share of course. > > > Best regards, > > Panayiotis Vlissidis > > > -- > > 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. -- 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.
