What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

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

1 Answer 1

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