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