To speed up transactions you can do all the basic tricks like disable
transaction log etc.
But usually an import is done only once when migrating from old to new.
Do you need to import on a constant basis?
Also, if you have thought of trying create table as select...
then why don't you just try it and see if it is faster?
But if you need to access 2 different databases then I don't think you
can apply "create table as select..." to that scenario.
--
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.
