r9245: New section on optimizations, especially optimizing JOINs

diff --git a/ChangeLog b/ChangeLog
index 30003681d31df24262520ef415566005ebb6b61e..f1431116c8e8c3033d4688456a1cab133d350e32 100644 (file)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,6 @@
+4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
+       * TODO: New section on optimizations, especially optimizing JOINs.
+

 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * Version 2.10.11
        * base/basic-sql.lisp: Avoid multiple evaluation
 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
        * Version 2.10.11
        * base/basic-sql.lisp: Avoid multiple evaluation

diff --git a/TODO b/TODO
index d63b9af6cb4d233dfe1911ea9326d0cb6afa9b9f..fee5fe3e7ab461357f01334fd37a8dd7aac38b77 100644 (file)
--- a/TODO
+++ b/TODO
@@ -44,6 +44,14 @@ COMMONSQL SPEC
 
       o variables (e.g., table identifiers) should be instantiated at runtime 
 
 
       o variables (e.g., table identifiers) should be instantiated at runtime 
 

+OPTIMIZATIONS
+
+* Revisit result-type list creation,perhaps caching
+* Use an inner join for :target-slot in SELECTS rather than multiple
+  queries. For example, in the test suite:
+    SELECT address.addressid,address.street_number,... FROM address
+      INNER JOIN employee_address ON employe_address.address_id=address.address_id
+      AND emplid=<id>

 
 POSSIBLE EXTENSIONS
 
 
 POSSIBLE EXTENSIONS