X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;ds=sidebyside;f=yarrg%2FTODO;h=28df53f9f430c8e93bdc3be5f5fa5471fa152aa4;hb=5f317a6465f48831fd170a745b58763602218421;hp=86883498ba949700ee771d3fd4ffb4b96652239b;hpb=fb82c8f168e216ee7e1964e57a867e5b49c7fa5c;p=ypp-sc-tools.web-live.git

diff --git a/yarrg/TODO b/yarrg/TODO
index 8688349..28df53f 100644
--- a/yarrg/TODO
+++ b/yarrg/TODO
@@ -1,7 +1,14 @@
 route optimiser
- - make debugging optional
+ performance improvements
+ - select * from buy, sell where
+       buy.commodid==sell.commodid and buy.price > sell.price;
+    and cache the results in core
+ - same for ite
  - fast version of rsvalue.c ?
- - performance improvements
+	time ./routesearch -DN 13460 20210 -1 0.005 search 30 7
+	46.478s	without -DN
+	 9.923 9.920 10.026 9.963 10.072 with -DN
+	 9.905 9.935  9.948 9.916  9.997 with debugging compiled right out
 
 create index sell_by_islandonly on sell (islandid, commodid, price);