16

When I use the Stack Exchange Data Explorer (SEDE), the results I get don't reflect recent activity. Sometimes the data I get back are two months out of date. What's wrong?

This is intended to be a canonical reference for questions about SEDE not reflecting real-time results.

Return to FAQ index

13

SEDE does not query the production database in real time. It queries a data dump that is updated weekly.

Updates used to be monthly, and manual. For real-time data, Jeff suggests using the API; see Stack Apps for more information about that.

Note that the SEDE data dump is not the same thing as the Creative Commons data dumps.

  • 2
    Why isn't it updated more often? I presume you do database backups; restoring the backups should be part of the process to ensure that the backups are usable and complete. Couldn't those restorations power the SEDE site? – Mark Ransom Apr 30 '12 at 21:25
  • @MarkRansom SEDE's data are not an exact snapshot of the live data, for example votes are anonymized before the data find their way into SEDE. – yannis May 1 '12 at 2:18
  • @YahooAnswersenthusiast, you could probably achieve that by exposing views rather than the raw tables. – Mark Ransom May 1 '12 at 2:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .