atg 2020 should imply atg
deactivateda0841fe
Ahhhhhhh heck. I accidentally aliased. Don’t worry I have all the posts open on a page and I can fix them. I just don’t have time to do it right now because I have to go to work. I removed the alias and added the correct implication if anyone happens to get to it before I do.
Background Pony #FDCD
Something seems to be weirdly cashed or so right now
I just added it to a bunch of stuff but most of them didn’t get the tag after saving
I just added it to a bunch of stuff but most of them didn’t get the tag after saving
deactivateda0841fe
@Background Pony #FDCD
It just needed to be reindexed. I went ahead and fixed it.
Edit: I still have to re-add the posts.
It just needed to be reindexed. I went ahead and fixed it.
Edit: I still have to re-add the posts.
Derpy Whooves 
Looking For My Doctor
@Background Pony #FDCD
Yes. In brief, indexes allow very rapid access to frequently required information in a database table (in this case, the tag). Sometimes things we do can screw up the accuracy of the index. Like - aliasing tags does that sometimes. Reindexing it means we toss out the old index and rebuild the index from scratch.
Typically things like “Social Security Number” is used as an index, because of the belief that SSNs are unique (although this is not actually true and can result in indexing problems if handled badly). Wow. I just had a flashback to the datawarehousing I did for some insurance companies. THAT was unexpected.
On this site, things like “How many times is a tag used”(the number following the tag) can get screwed up if the index for the tag has been messed with as the result of some of the mass tagging things we do.
BTW, Philomena is much better with indexes. When we were BooruOnRails if there was a competing processes like someone adding the tag at the precise moment someone else deleted it the index would end up in lala land. And trying to fix it was a crap shoot that could sometimes take days for jobs to complete.
So, on Philomena it’s much rare that these get out of order, but those are mostly limited to staff operations now, and when it does happen fixing it is super reliable and fast.
[edit: much rare]
Yes. In brief, indexes allow very rapid access to frequently required information in a database table (in this case, the tag). Sometimes things we do can screw up the accuracy of the index. Like - aliasing tags does that sometimes. Reindexing it means we toss out the old index and rebuild the index from scratch.
Typically things like “Social Security Number” is used as an index, because of the belief that SSNs are unique (although this is not actually true and can result in indexing problems if handled badly). Wow. I just had a flashback to the datawarehousing I did for some insurance companies. THAT was unexpected.
On this site, things like “How many times is a tag used”(the number following the tag) can get screwed up if the index for the tag has been messed with as the result of some of the mass tagging things we do.
BTW, Philomena is much better with indexes. When we were BooruOnRails if there was a competing processes like someone adding the tag at the precise moment someone else deleted it the index would end up in lala land. And trying to fix it was a crap shoot that could sometimes take days for jobs to complete.
So, on Philomena it’s much rare that these get out of order, but those are mostly limited to staff operations now, and when it does happen fixing it is super reliable and fast.
[edit: much rare]
deactivateda0841fe
@Background Pony #FDCD
Between you and someone else, all but one of them were retagged (which I did), so thanks for helping me clean that small bit up.
Everything in this thread should be good now.
Between you and someone else, all but one of them were retagged (which I did), so thanks for helping me clean that small bit up.
Everything in this thread should be good now.
Background Pony #FDCD
@Derpy Whooves
I see, thanks for the insight! It’s much rare - ;) <3 - that I dealt with databases and that was years ago
@Parasprite
Np, thanks too!
I see, thanks for the insight! It’s much rare - ;) <3 - that I dealt with databases and that was years ago
@Parasprite
Np, thanks too!
Interested in advertising on Derpibooru? Click here for information!
Help fund the $15 daily operational cost of Derpibooru - support us financially!