Hey guys. My apologies in advance if this is a slightly mundane question.
I'm running this code from a scripting language bound to SQLite:
%r = db.query("SELECT * FROM userTable", 0);
%i = 0;
db.query("BEGIN TRANSACTION", 0);
while (%i < db.numRows(%r))
{
%username = db.getColumn(%r, name);
db.query("UPDATE userTable SET playedInfIds='' WHERE name LIKE
'?'", 0, %username);
%i ++;
}
db.query("END TRANSACTION", 0);
This query takes about 5 seconds to process - which seems like a long
time. userTable has 3000 entries, and the name column is TEXT PRIMARY
KEY NOT NULL UNIQUE.
Is there anything obvious I'm doing wrong? I know using LIKE is not
ideal, but the scripting language does not guarantee case so it is
necessary here.
Thanks,
Ian
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
