Tavern on the Meta

12:11 AM

@cVplZ What, you didn't like my new title?

:( I thought it made it a ton clearer.

1:02 AM

@hichris123 yours was a more clear, descriptive title. But it didn't have the buzz, interesting title to enhance more clicks.

Undo

@JasonC you should have access to Smokey now

user259867

1:32 AM

Tricky question: which revision is shown in Reopen queue: second most recent, or the one that was closed? (At least, tricky to find the answer to.)

hichris123

@Rafflesiaarnoldii Grr! You changed your name again!

@Rafflesiaarnoldii IIRC it diffed to the revision before it was closed.

Let's try science!

user259867

That's what I wanted to try, but don't know how to set up an experiment.

hichris123

@Rafflesiaarnoldii It diffs to the revision before it was closed. stackoverflow.com/review/reopen/6165105 & stackoverflow.com/posts/26769367/revisions

user259867

Thanks! SO provides a lot of material for scientific experiments.

hichris123

@Rafflesiaarnoldii Indeed it does. :)

Jason C

1:36 AM

@Undo Oh, thanks.

hichris123

Oh btw free flags: patents.stackexchange.com/questions/10515/…

user259867

Looks like blatantly OT? Not spam.

hichris123

@Rafflesiaarnoldii That or "not a direct link to patent holder"

cVplZ

@hichris123 he's brick in the wall and world something?

Jason C

4 hours ago, by Jason C

cv-offtopic http://meta.stackexchange.com/questions/243057/is-there-anything-se-can-do-about‌-this-spam (in my strong opinion, anyways; given the new information)

Man, navigating the room info pages is infuriating. I feel like every link takes me to the transcript, the message search page, or the room itself, but exactly which of the three is entirely random.

Once I saw a list of posts starred by me, that was kind of cool. But then it was a graph. But then it was some user's profile. I tried to go back but just saw other peoples' bookmarked conversations. Then a CSV started downloading, my computer rebooted, a herd of cats ran through my apartment and my couch burst into flames.

cVplZ

1:43 AM

@ShadowWizard that is interesting! no Mark Booth to be found

user259867

I once looked for a way to get the list of a user's messages... that did not end well.

Jason C

So I'm trying to build a SEDE query to show answers, their timestamp, but also the timestamp of the question they belong to. I have this, but I keep getting internal resource errors, I guess because of the big join:

SELECT
  a.Id AS [Post Link],
  a.Id AS [AnswerId],
  q.Id AS [QuestionId],
  a.CreationDate AS [AnswerDate],
  q.CreationDate AS [QuestionDate]
FROM
  Posts a INNER JOIN Posts q ON a.ParentId = q.Id
WHERE
  a.PostTypeId = 2 AND
  q.PostTypeId = 1 AND
  q.ClosedDate IS NULL

Is there a different way to run this query that is a little more resource friendly?

hichris123

@JasonC Does adding a TOP 100 or similar make it happy?

Tim Stone

Urgh, we really need some indexes on those tables...but I'm afraid regenerating them every time the data is refreshed would be prohibitively expensive.

Andrew T.

@JasonC or add q.CreationDate to WHERE to make it cheaper

Jason C

1:57 AM

@hichris123 Hmm... Yes, actually. Although it doesn't make me happy; since this is going to be used for part of a bigger query and I want to get everything.

hichris123

@TimStone Did you ever get the latest code pulled?

Tim Stone

@JasonC Your PostTypeIds are actually doing more harm than good.

@hichris123 Everything I've put out has been pulled for a while (well, with the exception of that bug I fixed yesterday, which was pulled yesterday), but not deployed to the public instance. :(

hichris123

steps back and lets @TimStone do the magic

Tim Stone

SUCH SADNESS

Let me see if I can beat it into submission, but having to outsmart the server to get what you want is clearly not very usable. :P

hichris123

@TimStone Go ping Nick incessantly. That'll annoy him enough... maybe... ;)

Jason C

1:59 AM

@TimStone Oh I guess they are; I don't really understand how the optimizer works. But same issue without them.

@cVplZ I'm trying to find a list of all answers that were posted within a given amount of time of the question being posted.

Tim Stone

@JasonC Oh FFS, it can't even do the join itself.

sighs

Andrew T.

@JasonC I thought @cVplZ has this query used on his meta post?

cVplZ

@AndrewT. I have it only selecting the count

@AndrewT. I tried just selecting the [Post Link] , for answers left > 14 days and < 30 days and it ran out of resources

Jason C

@AndrewT. What post

cVplZ

@JasonC here

Jason C

2:07 AM

@TimStone I removed the [Post Link] column and its fine now.

Tim Stone

Hmmmmmm

hichris123

@cVplZ -1 still needs a better title. :P

Tim Stone

Indeed.

Let me look into that...

It looks like doing it this way might be marginally faster, but there appears to be an issue with the execution plans for some reason ( |: ) so I'm not sure if there's a good reason for that or not.

cVplZ

I just selected top 500 answers for this one, works good data.stackexchange.com/stackoverflow/query/242936/test

Jason C

@TimStone Thanks for checking.

Well, my grand plan to uncover unnoticed spam seed questions + answers seems to have failed. My query works but the results aren't nearly as awesome as I expected.

cVplZ

2:20 AM

@JasonC I've done something like that before. My reasoning was to just select the questions/answers that were both by new users, less than 30 days old accounts, and some other things. Didn't find too much.

Jason C

@cVplZ Yeah :/ I just looked for answers posted within 24 hours with questioner and answerer both with 1 (or whatever) rep.