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.

Possible Duplicate:
Data from the Stack Exchange Data Explorer are obsolete

I composed a simple query to show my answers with titles of corresponding questions, ordered by score. Many of my answers are missing there, for example:

In total, only 240 out of 266 answers are displayed. Where is the problem? Some delay? But why? I'm accessing the raw data in database directly, not some derived data (like rep or badges). Moreover, the "Regular expression ..." question is already 2 days old!

share|improve this question

marked as duplicate by Awesome Poodles, waffles Feb 17 '12 at 1:18

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
why was this downvoted? –  Tomas Oct 14 '11 at 13:57
3  
Maybe because this is not a very good question; it could have been answered by simply reading the Data Explorer FAQ or the about page. It's not as appealing to the eye as other site FAQs (and also a bit outdated, it seems), but it does mention that you're not querying the live database. –  lunboks Oct 15 '11 at 0:26

1 Answer 1

up vote 6 down vote accepted

The last update to the database was 10 days ago on October 4th. The Data Explorer is not updated with the most recent data automatically, it is done manually once every 1-2 months (the last update before this one was August 26th or so).

share|improve this answer
2  
A more real-time option is using our API. –  Rebecca Chernoff Oct 14 '11 at 13:09
    
@RebeccaChernoff, is it possible to compose queries online in a simple way like in the Data Explorer? –  Tomas Oct 14 '11 at 14:00
    
@jonsca, if its updated only 1-2 months (!!!) then I dare to say the Data Explorer is not of much use! –  Tomas Oct 14 '11 at 14:01
1  
@Tomas The data explorer is just a convenient front end to avoid having to download and load the massive data dumps, where the data dumps in turn are provided more for things like statistical analysis. –  Justin Oct 14 '11 at 14:49
    
@Tomas It's very useful for the reasons that Kragen has described. I think Rebecca's got a better idea. See the api.stackoverflow.com/1.1/help for the syntax for the API. –  jonsca Oct 14 '11 at 16:28
    
@RebeccaChernoff Well played, well played –  jonsca Oct 14 '11 at 16:29
    
Well played? Hm? –  Rebecca Chernoff Oct 14 '11 at 17:08
    
@RebeccaChernoff I hadn't even thought of the API when I was writing the answer. Just giving you credit. –  jonsca Oct 14 '11 at 17:12

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