chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-live.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
WIP routesearch; Cache relevant bits of database in memory
[ypp-sc-tools.db-live.git]
/
yarrg
/
TODO
diff --git
a/yarrg/TODO
b/yarrg/TODO
index ec4daed8f1eea74ed1ba673df509f9a61e808b63..bed30adc750a1cf9ec98803c54fdc95224a37d06 100644
(file)
--- a/
yarrg/TODO
+++ b/
yarrg/TODO
@@
-1,6
+1,10
@@
route optimiser
route optimiser
+ performance improvements
- fast version of rsvalue.c ?
- 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);
create index sell_by_islandonly on sell (islandid, commodid, price);