72Views6Replies

Author Options:

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

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."

Discussions

0
frollard
frollard

Best Answer 10 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.

0
kelseymh
kelseymh

Answer 10 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.

0
frollard
frollard

Answer 10 years ago

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.

0
DJ Radio
DJ Radio

10 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.

0
Jayefuu
Jayefuu

10 years ago

I was wondering that! Well asked!