Changes between Version 50 and Version 51 of DeveloperGuidelines/Optimisation

Timestamp:

06/18/10 09:57:51 (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)
+record2 = db(query).select(db.table2.ALL, limitby(0,1)).first()
+if record2:
+    ...
+}}}
+
 ----
 DeveloperGuidelines
-DeveloperGuidelines
-DeveloperGuidelines
+