[web2py] Re: How to define DAL query to retrieve items and theirs tags

2010-08-04 Thread David Marko
And how do you solve this in general? It seems to me very common thing. How to do it to minimalize database queries? (iIm not a SQL guy, my Job is Lotus Notes development) and recently I did project with MongoDB, which has quite different approach for this case) David On 4 srp, 11:29, mdipierro

[web2py] Re: How to define DAL query to retrieve items and theirs tags

2010-08-04 Thread mdipierro
That is a difference between NoSQL and RDBS. In web2py you can do it with one query+code but I would to it with three queries and cache: query = db.message.id0 tags_d = db(db.tag.id0).select(cache=(cache.ram,600)).as_dict() message_d = db(query).select().as_dict() links =