Faster pages, no more logged-out flash, big database speedup

Database speedup - some pages were running queries that scanned tens of thousands of rows when they only needed a handful, because of how the database indexes were set up. This was quietly generating an enormous amount of database work behind the scenes. Reworked the indexes and a couple of the heaviest queries so book, series, character and universe pages now read only the rows they actually need - a reduction of roughly a thousandfold on the hottest query path. Pages should feel snappier, especially the first time each one loads.

No more logged-out flash - when you opened the site while signed in, the header avatar, notification bell, and "Ready to contribute" banner often appeared late, or didn't show until you refreshed. The site now recognises your signed-in state immediately on load instead of waiting for a slow chain of background checks. Repeat visits render your signed-in header instantly. Signing in and out is unchanged.

Glossary organisation - continued tidying the glossary's category/sub-category structure: hundreds of entries across places, objects, groups, cultures and systems now have a proper sub-category (settlement, region, weapon, faction, magic, and so on), and a handful that were filed under the wrong type have been corrected.

More pages served from cache - most pages are now kept ready-to-serve for a day at a time instead of an hour, and the main listing pages (characters, books, series and so on) are served straight from a fast edge cache. For you that means pages load quicker and more consistently, and the site comfortably absorbs the constant stream of search-engine and link-preview bots instead of rebuilding pages for them over and over.