summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-10-12 19:25:37 +0200
committerYorhel <git@yorhel.nl>2015-10-17 17:20:41 +0200
commiteed1eced579e022135f98f3f733ecab88e3b6b6e (patch)
tree88e15c1475a9bf4f7b15c2c6ff1661fb52b77716 /lib/VNDB/DB
parent61251790bd1da10eebee3c56a70a9711e7680ce8 (diff)
SQL: Convert all item-tables to a different schema
This commit breaks pretty much everything. Lots of code will have to be fixed to work with this new schema. The basic idea is to separate live data from archived data, which allows for smaller and more effective indices on the live data, and the archived data doesn't need such indices and have to be accessed at all for most operations. Another goal is to eliminate table joins to fetch some necessary information, e.g. it's not necessary anymore to join the main item tables in order to fetch only the latest revision of some item data. This is very much work in progress. I might stumble upon some weird issue while fixing the code, and might have to redesign everything from scratch again. Let's just see how things go.
Diffstat (limited to 'lib/VNDB/DB')
0 files changed, 0 insertions, 0 deletions