when I am trying to do
insert into tabletmp select * from csvread('c:/temp/
dw.bcp',NULL,NULL,' ')
I am getting a message 'java heap space'
[In addition leaving partly filled table! - so no transaction control
on this one?]
insert into tabletmp select * from csvread('c:/temp/
dw.bcp',NULL,NULL,' ') limit 100000
works ok [the table has 5m rows, about 17 columns, numbers]
I suspect that csvread is trying to do everything in one go.
If so, the solution would be to introduce a new parameter to CSVREAD:
batchSize=N, default something like 10,000.
After each batchsize records read, commit the store and clear the
input buffers.
That will allow CSVREAD to be used for more than trival tables.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
