kevin922 0 #1 August 21, 2002 Why can't you sort by # of views anymore? Quote Share this post Link to post Share on other sites
scottbre 0 #2 August 21, 2002 Because... hehe "Your mother's full of stupidjuice!" My Art Project Quote Share this post Link to post Share on other sites
sangiro 26 #3 August 21, 2002 QuoteWhy can't you sort by # of views anymore? You never could on these forums... Post views (and thread views) are not stored in the forum database (Post) tables. Because of that, an index cannot be used and so the resulting query would be extremely slow. The post/thread views had to be moved to a separate table for a major speedup - every time someone viewed a post, it had to update the table. If someone also tried a search, things could get backed up and clog up the server, since MySQL locks the entire table to update a row. Obviously not impossible to do, just slow in mySQL (postgresql wouldn't have this problem), so the optimization remains.Safe swoops Sangiro Quote Share this post Link to post Share on other sites
