Instructables

Why does it take 45 minutes to an hour for the RECENT answers page to match the actual set of answers and Best flags?

Answer this question, then look at the summary page. If you're patient, periodically refresh it with your browser's [Reload] button, and see how long it takes to show "1 answer."

frollard5 years ago
I'm guessing the ibles robot doesn't query every answer in the database every time the answers page is loaded - I'm guessing that takes a LOT of querying... it makes more sense to have a few variables attached to each question of '# of answers" and "marked answered"...and then query THOSE variables each time the page is loaded... That means that instead of a query of the entire database of answers (comments) isn't hit (thousands and thousands of records) every time the page loads...just the top portion of the table of questions... The robot then only has to do a query of the questions table once...whenever it gets a chance...every 'little while' to update the variables.
kelseymh (author)  frollard5 years ago
I suppose, but..one "good" way to deal with that is to have the keys (# of answers, and marked) pushed into the database when they occur. Then the code which generates the summary table doesn't have to rescan everything every time.
indeed - I thought of that, but in typing my huge response it must have been missed from the pile-o-crap sitting in my brain. Pushing the variables in single queries would be a good thing...it opens yourself to a lot of errors if the query does not complete. The method being used keeps everything in check at the cost of being laggy. Perhaps using both - live updates with an hourly inventory/audit script could ensure accuracy.
DJ Radio5 years ago
The exact same thing happens with the "explore" pages. Ive seen the rating section of knex ibles, it takes around 45 minutes for a knex item to move according to its rating.
Kiteman5 years ago
Possibly the hamsters are tired?
Jayefuu5 years ago
I was wondering that! Well asked!