I have functionality which is actually taking more than 30 min to complete. The technologies that are used Java, Hibernate and Spring. This functionality deals with around 20 tables at a time. It like copying around 5000 recording with updating references for each Row. The complete code has is written in Java. Are there any special ways that will actually reduce this process to 1 min.
How about writing a procedure ?