Some of the time, we have to run/execute the SQL scripts using command prompt or the sql browser, but i were to replace these actions with just a single click of button, i need to create a functionality with java whereby users can perform these actions with an interface. But most of the time, the amount of scripts to run would be huge, taking that into account when were execute sql scripts from the java classes, what would be the major considerations that we cant neglect in order to ensure performance's optimization?
Your comment, guidelines, or suggestions would be very much appreicated!