how to improve upload performance?
I am new in java upload excel data to db. Currently I had do some performance testing with 10 thousand rows of records in excel to be inserted into db, and it took around 40 second. I am looking forward to reduce the time taken even more. I am very much appreciate for any suggestions or idea from you all.
I am using org.apache.poi to get the data out from excel using jsp, then insert save the data into a table. There is no table join or big linking is used.
Please help me in this knotty problem, thank you.