Hi...
DB: oracle 8.1.6
server: Apache(?) + tomcat(4.0.2)
data: 000@111@aaa@bbb@ccc ~~~ : 20 ~ 30 col
i insert and delete 20000~30000 rows data everyday.
the run time is usual 5 minutes.
i wants reduce time....
while (stringLine != null) {
StringTokenizer st = new StringTokenizer(stringLine);
for (int i =1; i<= j; i++) { // j = 20 ~ 30
pstmt.setString(i,st.nextToken("@"));
}
pstmt.executeUpdate();
stringLine = br.readLine();
}
thank