Changes between Version 24 and Version 25 of DeveloperGuidelines/Optimisation

Timestamp:

06/16/10 18:54:49 (14 years ago)

Author:

Fran Boon

Comment:

--

DeveloperGuidelines/Optimisation

@@ -43 +43 @@
 ----
 {{{
-value = db(table.id==id).select(table.field, limitby=(0, 1))[0]
+value = db(table.id == id).select(table.field, limitby=(0, 1)).first()
 }}}
 runs 1.5x faster than:
@@ -50 +50 @@
 }}}
 (0.012 vs. 0.007 seconds vs in a test case)
+
+NB If only expecting one record then the limitby provides a big speedup!
 
 Javascript string concatenation: