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

This SO question is clearly a candidate for Meta, but I have to go read it to see if it was only closed, or migrated to where it belongs. Can't the text say [migrated to meta] instead of [closed] when that's what has happened?

Tell me it has been migrated in the question title! Please?

share|improve this question
    
+1 because "(this q isn't closed!)" amuses me –  Pops Apr 5 '10 at 17:03
    
Coming back to this a year later, I find that title to be kinda confusing. I've edited it out; it's against policy now, anyways. (But I'm not un-upvoting). –  Pops Mar 11 '11 at 20:31
1  
another idea ahead of its time! –  Jeff Atwood Apr 10 '11 at 3:34
add comment

1 Answer

up vote 9 down vote accepted

This would require denormalizing the value, which isn't worth it IMO.

Clicking through will show you exactly what happened.

edit: we did eventually denormalize this as MigrationDate, and there are lots more migrations now that we have 40+ sites, so -- implemented as [migrated] on questions instead of just plain [closed].

share|improve this answer
1  
What it means denormalizing the value? –  Tshepang Mar 11 '11 at 20:50
1  
@Tshepang, data is stored in many different database tables, and to get or calculate some details, many tables must be combined (joined) to get that. That might be slow, and therefore some details might not be available on pages that are requested by many visitors. To speed up things, some data might be kind of duplicated and then a copy of, for example, the last migration date can be stored in the same database table that holds details such as question title and body. (Likewise each vote is known, so the total score can be calculated. But the total itself is also stored for quick access.) –  Arjan Apr 10 '11 at 8:08
add comment

You must log in to answer this question.

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