It depends. It may.
For example given:
db.define_table('person',Field('name'),format='%(name)s')
db.define_table('dog',Field('name'),Field('owner','reference dog'))
if you do:
SQLFORM.grid(db.dog.owner==db.person.id)
it will do a recursive select for each row to find a representation of
db.dog.owner.
You can disabled this:
db.dog.owner.represent = None
SQLFORM.grid(db.dog.represent==db.person.id)
or hide it
db.dog.owner.readable = False
SQLFORM.grid(db.dog.represent==db.person.id)
or cache it:
db.dog.owner.represent = lambda v,r: cache.ram('person-%s'%v, lambda v=v: v
and '%(name)s'%db.person(v), None)
SQLFORM.grid(db.dog.represent==db.person.id)
You can always add the {{=response.toolbar()}} to see all the database
queries.
On Wednesday, 9 October 2013 14:39:07 UTC-5, James Thompson wrote:
>
> When using SQLTABLE (or something like: {{=query_results}}) to display
> rows in a view, foreign key fields display data from their related table.
> Is web2py doing individual queries for each of these fields?
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
