Repository :
http://git.fedorahosted.org/cgit/
On branch : master
---------------------------------------------------------------
commit 1979aada3b8ae153a87fe59c176fe94aa01e864a
Author: Matt Domsch <matt(a)domsch.com>
Date: Wed Jul 24 23:41:01 2013 -0500
add EXISTS to TODO
---------------------------------------------------------------
TODO | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/TODO b/TODO
index 7f62cf9..cbe8f69 100644
--- a/TODO
+++ b/TODO
@@ -14,7 +14,10 @@ Short Term:
* move Fedora-specific apps into a server/fedora directory, add
/usr/share/mirrormanager/server to sys.path.
* crawlers failing after a 90min timeout - why?
* consider making http redirects only redirect to http servers, not FTP (fixes bfo/ipxe)
-
+* publiclist_hosts() query should use an EXISTS clause to reduce query
+ time considerably. The long list of directories and
+ HostCategoryURLs currently being generated by the joins is crazy, an
+ EXISTS clause should be able to reduce that to a single row.
Long Term: