I am new to Database.
I am tying to insert 22000 word to a sqlite DB but it is taking forever to complete
for (int i=0;i String sql = "INSERT INTO WORD (word) VALUES ("+"'"+s.get(i)+"'"+");";
statement.executeUpdate(sql);
}
Table name is WORD and field name is word(which is a String
)
Here s is an arrylist and s.get(i) returns a string... I have made the connection and trying to update
the table.
It is very slow. What am I doing wrong?
No comments:
Post a Comment