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_tuning
>
> 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.
