I asked https://stackoverflow.com/q/16984187/1544337 yesterday or so and today I noticed it was closed as not constructive. Earlier, I already saw an NC vote, and also a too localized one. Now, there is an off topic vote and I don't see that at all!

I don't see how any of these close reasons apply on this question.

For not constructive:

  • Answers can be supported by facts, references and expertise
  • I don't see how this is polling or could create debate or discussion

For too localized:

  • This is not specific for a specific moment or geographic area
  • Also not specific to any other thing, like my code or so, because it was a general question

For off topic:

  • Well, it's about a specific programming problem, and
  • software tools commonly used by programmers

I would really appreciate it if anyone can explain to me why this was closed as not constructive.

  • 11
    I can see a few possible reasons: First, the answer is a simple yes or no. Second, there is a whole lot of extra text surrounding what is a simple question that is asked entirely in the title. Third, a Google search has the answer as the first hit. – George Cummins Jun 10 '13 at 17:04
  • 2
    @GeorgeCummins: all of those could be reasons for downvotes (or edits, as appropriate), but that wouldn't make it NC or "too localized". (Even NARQ could be argued). – Joachim Sauer Jun 10 '13 at 17:05
  • Aaaand ... it's been reopened. So does this question become "too localized" now? ;-) – Joachim Sauer Jun 10 '13 at 17:10
  • 3
    Perhaps people need to be a little more careful in the close vote queue: stackoverflow.com/review/close/2272325 – Brad Larson Jun 10 '13 at 17:11
  • 3
    On my part, I voted to close this question because the answer was simply 'yes', which you could have found using google: mysql query caching yields exactly the answer you were looking for and directly on the MySQL website. Ironically, the answer you've accepted references the first result in the search I mention above. QED? – nickhar Jun 10 '13 at 18:17
  • @nickhar I wasn't aware of the fact that a simple yes/no or google question is NC or TL. Thanks for the clarification. – Keelan Jun 10 '13 at 18:19
  • 1
    @CamilStaps I don't thinks it's that clear-cut. The trouble is it's a subjective area, but in your case (from my perspective) an easily 'findable' answer... +1 for bringing it on MSO though. – nickhar Jun 10 '13 at 18:24

This is one of the problems with having so many questions on Stack Overflow, you attempt to pummel the vision into people and some take it too far when something that sits on the edge comes along.

This does sit on the edge, I had a serious think about moving it to DBA.SE, but I don't think it merits it. Branko has answered the question to your satisfaction and that should be the end to it.

The first two users to vote to close are new to their powers and I can't blame them for voting this way. People do try their absolute best to keep the site clean and sometimes something slips through the net.

As for the close reasons, Not Constructive I really don't see. Off Topic, as I've said this could be migrated to DBA but then maybe it's a bit simple so just off-topic it is (though it is about programming), which brings us onto Too Localized. It might be this, if all that was required to answer the question was to read the documentation then maybe it is a little localized, and if that's all the answer was I'd probably be voting to close again. Then again maybe not, a good explanation has been given and everyone's happy.

What I'd like to emphasise is that this is not "over moderation". It was closed by the community and can be re-opened by the community (this has happened). Even if it had been closed by a moderator it could still be re-opened by the community...

| improve this answer | |
  • And now it has been migrated :) but thanks for your clear answer! – Keelan Jun 11 '13 at 6:47

Given that I was one of the users who voted to close your question I thought I'd upgrade my comment to an answer in view of other comments and viewpoints.

In this case, my reasons for closure were several-fold:

  • Your base question was indeed answerable with a 'yes' or 'no' (there were other more complex questions included in your post, but that didn't address your initial and posted question).
  • The question was (and remains) easily discoverable by performing a number of searches both on Google and SO that prove some basic level of research - something that most (ok, some) users understand as prerequisites to asking any question on SO.
  • By asking myself: "Will this question benefit others in it's context and content".
  • Most people working with MySQL and PDO are usually aware of the MySQL query cache (that gets invalidated under various conditions as new answers have mentioned).

With hindsight, closure on the basis of Not Constructive was perhaps incorrect (although you made no references to any research). However, there isn't an option for me or anyone else to close on the basis of "You haven't done any basic research which would have answered your primary question" or a custom reason; Reasons that sometimes fall outside the categories that we're forced to choose from - as others have outlined as potential edge-cases.

Ironically, after your question was re-opened, you accepted an answer from a high-rep user (higher-rep usually instills a higher level of trust) that was basically copy-and-pasted from the MySQL website; A page that is the top result if you had googled for: mysql query caching (or other similarly worded searches) and which was, really, the underlying point of my vote to close.

Whilst I didn't see prerequisite research in the initial question, given your post here on MSO, I do see a wish to learn and expand your knowledge (like all of us) - nothing but a great thing from my perspective and perhaps your questions from here will benefit from this process :)

As echoed by other comments and answers, sometimes, closure is subjective and why MSO should be used where that subjectivity needs to be called into question.

| improve this answer | |
  • 4
    There's a reason why there's no "No research done" close reason: It doesn't exist. If you hover over the vote button for questions, the site says, "This question does not show any research effort." That's what you're supposed to do to questions that don't show effort: vote them down. – George Stocker Jun 11 '13 at 1:48

It may be another case of over moderation, however it's pretty much a yes or no answer. I think people reviewing questions are more inclined to close questions of that nature without really thinking too much in to them.

| improve this answer | |

You must log in to answer this question.

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