UPDATED Hello, I saw that I had forgotten a drop oracle alias table in the script insertion, but not used. After removing everything seems OK in time.
I have returned to create manually, but I could not recreate the problem, all times are OK. Thanks, I'm reviewing it, and if I find something else I shall tell you. On 8 abr, 20:17, pepillo4 <[email protected]> wrote: > 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.
