In article <[email protected]>, Rob Williscroft <[email protected]> wrote: > >db.execute( ''' > update "sessions" set "uid" = ? > where "uid" = ? > and exists( > select * from "users" where "uid" = ? > ) > ''', > (v['uid'],s.SID, v['uid']) > )
This will be more efficient if you do "select uid from users". -- Aahz ([email protected]) <*> http://www.pythoncraft.com/ "It is easier to optimize correct code than to correct optimized code." --Bill Harlan -- http://mail.python.org/mailman/listinfo/python-list
