Changes between Version 9 and Version 10 of DeveloperGuidelines/Optimisation

Timestamp:

11/16/09 16:24:14 (15 years ago)

Author:

Fran Boon

Comment:

Explicit select example

DeveloperGuidelines/Optimisation

@@ -11 +11 @@
  * If a specific inner-loop routine canot be optimised in Python, then consider writing a C routine for this use case.
 
+=== Specific Examples ===
 {{{
 for i in range(0, len(rows)):
@@ -19 +20 @@
  for row in rows:
 }}}
-(0.05 vs. 0.001 seconds in my test case).
+(0.05 vs. 0.001 seconds in a test case).
+----
+{{{
+value = table[id].field
+}}}
+runs 1.5x faster than:
+{{{
+value = db(table.id==id).select(table.field, limitby=(0,1))[0]
+}}}
+(0.012 vs. 0.007 seconds vs in a test case)
 
 === Profiling ===