Changes between Version 40 and Version 41 of DeveloperGuidelines/Optimisation

Timestamp:

06/18/10 08:47:22 (15 years ago)

Author:

Dominic König

Comment:

--

DeveloperGuidelines/Optimisation

@@ -143 +143 @@
 {{{
 for id in ids:
-   my_record = db(mytable.id == id).select().first()
+   my_record = db(db.mytable.id == id).select().first()
    ...
 }}}
@@ -149 +149 @@
 (much) better:
 {{{
-records = db(mytable.id.belongs(ids)).select()
+records = db(db.mytable.id.belongs(ids)).select()
 for record in records:
    ...
+}}}
+
+It could be hidden...:
+
+{{{
+for x in y
+  id = some_function(x)
+  if id:
+    record = db(db.mytable.id == id).select()
+}}}
+
+better:
+
+{{{
+ids = filter(lambda x: some_function(x), y)
+records = db(db.mytable.id.belongs(ids)).select()
 }}}
 
@@ -159 +175 @@
 DeveloperGuidelines
 DeveloperGuidelines
+DeveloperGuidelines