Hello, when I do a mass insertion on H2 tables, through connection to oracle alias, for example (of many tables and records):
"create linked table tabla_alias(null, 'jdbc:oracle:thin:@x.x.x.x:x:pid', 'user', 'passwd', 'tabla_oracle'); insert into tabla_h2 select * from tabla_alias where ....; DROP TABLE tabla_alias .... more tables ... " When executing a intensive stored procedure in BBDD, in an i7 quad- core, time of execution is over 8 sg. If on that BBDD, export the schema (org.h2.tools.Script), turn off the BBDD, and recovery scheme (org.h2.tools.RunScript), time low to 2 sgs. Do I have make something after the "inserts" for not doing the backup/ restore and the time down?. Thank you, -- 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.
