Hi, > SET UNDO_LOG 0 - turns off undo log (I do not need rollbacks) > SET LOCK_MODE ? > SET LOG ?
I wouldn't disable the undo log, unless you have very large transactions. Also, I wouldn't change the other settings unless you fully understand what those mean - see the documentation for more information. > Clustered indices are designed for that sort of thing, but AFAIK H2 doesn't > support that yet; maybe when the new page store scheme is implemented? Yes, that's the plan. Clustered indices should be easy to add once the "page store" is done. > settings ... for optimizing queries on large tables Sorry, I don't think there are settings that would help. 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 -~----------~----~----~----~------~----~------~--~---
