From 89465a80557c2b03b9701b4239a34ded292eb018 Mon Sep 17 00:00:00 2001 From: "Kevin M. Rosenberg" Date: Wed, 5 May 2004 09:09:35 +0000 Subject: [PATCH] r9245: New section on optimizations, especially optimizing JOINs --- ChangeLog | 3 +++ TODO | 8 ++++++++ 2 files changed, 11 insertions(+) diff --git a/ChangeLog b/ChangeLog index 3000368..f143111 100644 --- 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 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= POSSIBLE EXTENSIONS -- 2.34.1