In article <xns9c08e179b66d8rtwfreenetremovec...@216.196.109.145>, Rob Williscroft <r...@freenet.co.uk> 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 (a...@pythoncraft.com) <*> 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
