I have a Java application that reads a .txt file, validates the informations and then executes several inserts into de Derby 10.5 database. The problem is that when i have a lot of inserts (more than 1000), the execution of these inserts gets slower and slower until it gets unsupportable for the user to wait.
I made a test, inserting the same lines of the file into an Oracle 10g database, and it worked pretty well.
So, is there any configuration, or otimization on Derby that i can perform to make it work???
Thanks for the attention
Fabrício Pedroso Jorge.
Administrador de Banco de Dados Trainee - SEFA-PA
Bacharel em Ciência da Computação - CESUPA
Resumo Profissional (Professional Skills):