simonw / git-history

Tools for analyzing Git history using SQLite
Apache License 2.0
191 stars 18 forks source link

Add index on `item_version._item` #38

Closed simonw closed 2 years ago

simonw commented 2 years ago

Looking up all versions of a specific item is a very common operation.

simonw commented 2 years ago

But when should I add this index? Ideally I would add it when the table is first created, but doing that concisely is blocked on:

So I guess I add the index at the very end of the script instead, at least for the moment.