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?