I'm testing different insert scenarios. I was surprised to find that doing "insert into .. select * from .." from a large table is an order of magnitude slower than running individual "insert" commands for each row from a file. That is, if I load file -> table A with insert commands, then do "insert into B select * from A", the latter is 10x slower than the former.
Also, "create table B ... as select * from A" is impossibly fast. I'm guessing this is not touching the disk unless it's in a transaction, or something. Are these results expected, or is something off? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
