Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Game player 'detail' link should lookup model for inbound links directly to games #57

Open
amj opened this issue Aug 22, 2019 · 2 comments

Comments

@amj
Copy link
Collaborator

amj commented Aug 22, 2019

e.g.

https://cloudygo.com/v16-19x19/joseki/full/1548398561-tpu-player-deployment-d74dbc759-27cfr-7.sgf

@sethtroisi
Copy link
Owner

This requires an index on filename which increases database size ~30% which will be >10gb so I'm going to not implement at this time.

If there are more use cases (than joseki explorer) I'm happy to reconsider.

@sethtroisi
Copy link
Owner

sethtroisi commented Sep 7, 2019

start = 52.1 gb

sqlite> delete from games where model_id not between 16000000 and 16999999;

vacuum => 6.2 gb

sqlite> delete from eval_games where model_id_1 not between 16000000 and 16999999;

vacuum => 5.5 gb

eval_models, model_stats

vacuum => 5.4 gb

CREATE INDEX game_name ON games (filename);

=> 6.8 gb

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants