tried it but combined time of 50 secs jumps to at least 100 secs. again thanks for the suggestion; was worth trying.
On Saturday, September 23, 2017 at 5:10:02 PM UTC+10, Noel Grandin wrote: > > you might want to create the table first and do a INSERT INTO ... SELECT > FROM CSVREAD​ > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
