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

Reply via email to