[sqlalchemy] Re: Many to many optimization

2007-04-12 Thread Kaali
(A.c.somecriterion=='foo').list() theres also some patterns for dealing with large collections at: http://www.sqlalchemy.org/docs/ adv_datamapping.html#advdatamapping_properties_working On Apr 2, 2007, at 7:44 AM, Kaali wrote: Can i use ORM many-to-many relations and filter SQL -side? If i can't

[sqlalchemy] Re: Many to many optimization

2007-04-12 Thread Kaali
will recreate that situtation later and see where to slowdown is. I'll also give some more implementation details so that you can see if there just a stupid mistake i have made that makes SA slow. -- K On Apr 12, 6:17 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Apr 12, 2007, at 3:30 AM, Kaali wrote

[sqlalchemy] Designing a permission system

2007-04-10 Thread Kaali
Hi, I'm designing a permission system to our messaging platform. The platform has different channels which contains messages. Every different user can have different permissions on a channel. The permissions are create, modify, delete. With these permissions, we can define that some users can

[sqlalchemy] Many to many optimization

2007-04-02 Thread Kaali
Hi everyone, I'm creating a web service using CherryPy + SQLAlchemy. So far, coding has been a pleasure, but it seems that i have a bit of a performance problem with my software. In short, the service is a messaging system, where users can send, receive and browse messages in different