X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.web-live.git;a=blobdiff_plain;f=yarrg%2FTODO;h=28df53f9f430c8e93bdc3be5f5fa5471fa152aa4;hp=ec4daed8f1eea74ed1ba673df509f9a61e808b63;hb=5f317a6465f48831fd170a745b58763602218421;hpb=ea160a28fd378be423dfe60d9ad3bdfa6f0d8295 diff --git a/yarrg/TODO b/yarrg/TODO index ec4daed..28df53f 100644 --- a/yarrg/TODO +++ b/yarrg/TODO @@ -1,6 +1,14 @@ 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 ? - - 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);