on 02-04-2016 12:55 PM
Hi
I have run an xs job for deleting records of a huge table. It ran successfully for one table, but the other table which is huge it ran for an hour and finally when i checked the record count din't move.
What has happened or what can be the reason for this ?
Code please
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
var sql = "DELETE FROM \"" +
input.schema +
"\".\"" +
input.table1 +
"\" WHERE \"" +
input.col1 +
"\"" +
" NOT IN " +
"(SELECT \"" +
input.col2 +
"\" FROM " +
"\"" +
input.schema +
"\".\"" +
input.table2 +
"\")";
var conn = $.db.getConnection();
var pstmt = conn.prepareStatement(sql);
//pstmt.executeUpdate();
var rows = pstmt.executeUpdate();
conn.commit();
conn.close();
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.