17

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

Improve this question
0

1 Answer 1

Reset to default
14

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.

Improve this answer
3
  • 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
    Commented Apr 30, 2012 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
    Commented May 1, 2012 at 2:18
  • @YahooAnswersenthusiast, you could probably achieve that by exposing views rather than the raw tables.
    – Mark Ransom
    Commented May 1, 2012 at 2:22

You must log in to answer this question.

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