Changes between Version 52 and Version 53 of DeveloperGuidelines/Optimisation

Timestamp:

06/18/10 10:03:34 (15 years ago)

Author:

Dominic König

Comment:

--

DeveloperGuidelines/Optimisation

@@ -201 +201 @@
 }}}
 
-The nested case:
-
-{{{
-for id in ids:
-  record1 = db(db.table1.id == id).select().first()
-  if record1 and record1.some_attribute == some_value:
-    record2 = db(db.table2.id == record1.some_key).select().first()
-    if record2:
-        ...
-}}}
-
-...if there is nothing to else to do with the table1 records, try instead:
-
-{{{
-query = (db.table1.id.belongs(ids)) & \
-        (db.table1.some_attribute == some_value) & \
-        (db.table2.id = db.table1.some_key)
-rows = db(query).select(db.table2.ALL)
-for record2 in rows:
-    ...
-}}}
-
 ----
 DeveloperGuidelines