From: Kevin M. Rosenberg Date: Wed, 5 May 2004 09:09:35 +0000 (+0000) Subject: r9245: New section on optimizations, especially optimizing JOINs X-Git-Tag: v3.8.6~515 X-Git-Url: http://git.kpe.io/?p=clsql.git;a=commitdiff_plain;h=89465a80557c2b03b9701b4239a34ded292eb018 r9245: New section on optimizations, especially optimizing JOINs --- 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