db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 鲍少明 <ioker...@gmail.com>
Subject load multiple same format csv files in one SYSCS_UTIL.SYSCS_IMPORT_TABLE call
Date Fri, 30 Dec 2011 01:27:46 GMT
I think this could be an improvement.

Can we extend the existing SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure
to support bulking-loading multiple same format csv files in one call?

I think it will not be difficult to use  something like SequenceInputStream
to load those files.

I hope this can be performance enhancement to loading those files which has
been splitted into pieces.

I was trying to use multi-thread, but I find that in the procedure ,it will
lock the whole table.

What should I do if I think using this SYSCS_UTIL.SYSCS_IMPORT_TABLE
procedure and
using derby in in-memory mode is still not fast enough?

Best Regards

View raw message