-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Simetrical wrote:
If we don't want to use the {category,page}links tables, by the way, why create another table that will amount to two booleans per page/category? Create a category table, which I think has been discussed anyway, and then add a boolean column or two to each of the category and page tables. Is there any point in adding two more 1:1 tables to store a couple of bits each?
The main advantage would be that we wouldn't have to do a big schema change operation to alter the page table. :)
I'm also not sure if there are issues of lock contention when updating link tables, but I'll leave that to the db-heads. :)
- -- brion vibber (brion @ wikimedia.org)