X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=TODO;h=fee5fe3e7ab461357f01334fd37a8dd7aac38b77;hp=d63b9af6cb4d233dfe1911ea9326d0cb6afa9b9f;hb=89465a80557c2b03b9701b4239a34ded292eb018;hpb=f469a630aeb903c0574dea5b1ac478bed182d072

diff --git a/TODO b/TODO
index d63b9af..fee5fe3 100644
--- 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