Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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

share|improve this question

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.

share|improve this answer
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 .