LogFAQs > #84

Topic List
Page List: 1
Topic"whoops"
GuessMyUserName
05/22/19 5:23:58 PM
1
Finished up the necessary work for what I said I'd do - reorganized posts and pulled out topics into a master list that holds its own database information so you don't have to manually navigate all that mess anymore. Also cleaned up some misplaced posts in the process but not a big difference.

So a topic.php page no longer needs any Database selectors (automatically handled by the tid info). In the topic list I replaced it with a year selector so you can still segment navigation a bit. A post info page (post.php) left as is and that's fine, not worth any effort to readjust that.

Also in the process optimized index a bit better so browsing won't be be such a slog every page (whoops beforehand I had the archived logs aka everything but the active log completely unindexed). I'm still don't have a perfect grasp of optimal indexing but definitely a lot better now.

That being said the only thing really tweaked so far is just the topic list and topic pages... pretty significant on its own yes, but other pages so far are mostly unaffected for now. The Boards List is still only going to show active database info, user profiles still use a database selector... as will search pages which are also still greatly unoptimized and slow, and post searching still uses the database selector too. Searching topic titles should be good though since that uses topics.php

Making this post now since I'll be busy with Anime North prep for the weekend, so more work will wait til Monday... mostly. May tweak a few small things but who knows.
Topic List
Page List: 1