r9245: New section on optimizations, especially optimizing JOINs

[clsql.git] / TODO

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 
 
+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