Re: [sqlalchemy] Re: Speed matters

2011-06-02 Thread fribes
Hi Sergey, I'll give it a try, thanks ! On 2 June 2011 03:15, Sergey V. sergey.volob...@gmail.com wrote: Hi, One easy/obvious improvement would be to delete all user's identifiers and groups at once without iterating over them for every user. Actually, iterating over the list of user_ids

[sqlalchemy] Re: Speed matters

2011-06-01 Thread Sergey V.
Hi, One easy/obvious improvement would be to delete all user's identifiers and groups at once without iterating over them for every user. Actually, iterating over the list of user_ids is not necessary too I think. code session.query(Identifier).filter(Identifier.user_id.in_(user_ids)).delete()