Does derby have abilities from carrying out a load place of information from the CSV? The very best I possibly could develop ended up being to read within the file line by line and make up a batch sql update statement and run that. For a million rows that required between 30-40 minutes, as in comparison with using mySQL's LOAD statement to load from the csv file which required 2-3 seconds for the similar data

syscs_util.syscs_import_table is going to do what you would like. Here's the paperwork: http://db.apache.org/derby/docs/10.5/tools/rtoolsimport91458.html#rtoolsimport91458