i think i have a memory problem in the java oracle driver as i am using it.
when i do a batch insert with 1000 lines it takes 2 seconds with 3000 lines it doesn’t take 6 seconds but 40 seconds.
If I insert 3000 lines then delete them immediately and insert them again, the second 3000 lines only take 7 seconds if I stay within my thread.
can it be that the driver or the DB need time to prepare for the amount of data and can i start the preparation manually while I’m searching for the data I want to insert afterwards?
New contributor
C J is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.