github
html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
https://github.com/simonw/sqlite-utils/issues/350#issuecomment-987015063 | https://api.github.com/repos/simonw/sqlite-utils/issues/350 | 987015063 | IC_kwDOCGYnMM461KeX | 9599 | 2021-12-06T17:55:42Z | 2021-12-06T17:55:42Z | OWNER | API could be this: ```python id = db["columns"].lookup( {"namespace": namespace_id, "name": column}, cache=True ) ``` This could default to a 100 item LRU cache. You could perhaps modify that with `cache_size=500` or with `cache_size=None` to disable the size limit on that cache. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1072435124 | |
https://github.com/simonw/sqlite-utils/issues/350#issuecomment-987015327 | https://api.github.com/repos/simonw/sqlite-utils/issues/350 | 987015327 | IC_kwDOCGYnMM461Kif | 9599 | 2021-12-06T17:56:05Z | 2021-12-06T17:56:05Z | OWNER | Should I implement this remember to apply the optimization in `git-history`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1072435124 | |
https://github.com/simonw/sqlite-utils/issues/350#issuecomment-987016019 | https://api.github.com/repos/simonw/sqlite-utils/issues/350 | 987016019 | IC_kwDOCGYnMM461KtT | 9599 | 2021-12-06T17:56:57Z | 2021-12-06T17:56:57Z | OWNER | Would be interesting to micro-benchmark this to get an idea for how much of a performance boost it is, since the indexed SQLite lookups used by `table.lookup()` should be really fast already. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 1072435124 |