WIP routesearch; next optimisation to do (callgrind says SQL is 50%)

[ypp-sc-tools.web-live.git] / yarrg / TODO

diff --git a/yarrg/TODO b/yarrg/TODO
index 2f59cba41c47305b870f9045a92f7ddaa81fb9f6..28df53f9f430c8e93bdc3be5f5fa5471fa152aa4 100644 (file)
--- a/yarrg/TODO
+++ b/yarrg/TODO
@@ -1,57 +1,47 @@
+route optimiser
+ 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 ?
+       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);
+
+
+
 UPLOADER
 --------
 
-P C    fix uploader to work with ceb's desktop and laptop
+detect all unexpected mouse movements
 
-       more flexible installation arrangements
+more flexible installation arrangements
 
-  W    windows uploader
+figure out why pctb.ilk.org isn't working
+
+windows uploader
 
 DATABASE/DICTIONARY MANAGER
 ---------------------------
 
-       commodity mass/volume in live database
-       eliminate black dye from live database
-
-O N    yppedia distance scraper finish
-O N    yppedia also cross-check arch/island pages
-O N    for server, take ocean/island data from database
+eliminate black dye from live database
 
-       when update rejected print better error message including
-        broken commodity name
+when update rejected print better error message including
+ broken commodity name
 
-       notice commodities deleted from source-info and warn about them
+notice commodities deleted from source-info and warn about them
 
+support Opal and Jade (currently there are some unicode problems)
 
 WEBSITE
 -------
 
-       multi-visit routes / circular routes
-
-       adjustable potential cost of losses (rather than fixed
-               1e-BIG per league)
-               use power formula (compound interest)
-               suggest 0.5%
-
-       show distance sailed in voyage plan
-
-       initial/final stocks feature
-
-       max volume/mass
-
-       max capital
-
-       better documentation
-
-
-KEYLETTERS
-----------
-
-P      needed before public release
-O      needed before public release to support multiple oceans
+allow unticking based on minimum margin or minimum profit
 
-C      needs ypp client and network connection
-N      needs network connection
-W      needs to be done by someone with Windows
+initial/final stocks feature
 
-D      dependencies unsatisfied
+printable voyage trading plan