Changes between Version 80 and Version 81 of DeveloperGuidelines/Optimisation

Timestamp:

11/02/12 04:42:57 (12 years ago)

Author:

Michael Howden

Comment:

--

DeveloperGuidelines/Optimisation

@@ -52 +52 @@
  7. Mind your field representations! Sometimes they execute complex DB queries, which behave fine with just a few test records, but become a nightmare with 10000 records. To be sure - test loading a form/list view with 10000 records in the table.
 
+ 8. Be careful with how you user Storages & Rows:
+|| For Variable || A || B (optimized) || Time A || Time B ||
+|| x = Storage(a="abc") || x.a || x["a"] || 1.064 || 0.39 ||
+|| x = Storage() || x.a = "b" || x["a"] = "b" || 0.49 || 0.24 ||
+|| row = s3db.pr_person[1] || row["first_name"] || row.first_name || 0.25 || 4.18 ||
+|| table = s3db.pr_person || "first_name" in table || hasattr(table, "first_name") || 0.74 || 0.42 ||
+|| table = s3db.pr_person || "first_name" in table || table.first_name || 0.74 || 0.27 ||
+
+
+
 === XSLT ===