→ 1 message moved to Sandbox/Trash Bin/Something

Hi Guys, wondering if any of the SEDE magicians could have a look at my answer about site metrics here: meta.stackexchange.com/a/332430/361484 and if that is achiavble with SEDE. My gut feeling is that it should be possible, but no SQL wizzard here ;)

@Luuklag takes forever: data.stackexchange.com/stackoverflow/query/1094823

if you run it a couple of times most of the data is in memory and then it completes in time

Thx a lot @rene. Ill have a try on a computer tomorrow. Almost out of battery on my mobile.

@rene

Just tried in on a computer, but only getting 100 returned in about 6ms

Would it be helpfull to add intermediate results for debugging?

Or is it because I'm not registered with SEDE?

Even tried switching to a smaller site (IPS)

@Luuklag data.stackexchange.com/interpersonal/query/1094960

cool, thx. Seemed that last conversion line did the trick

@Luuklag yeah, if you keep dividing integers, the result will be an integer

yup

now running on SO

hoping caching will come in soon

@rene, been looking at the results at IPS, with Q = 2453 and A = 12748 the avg A/Q should be about 5,5. And we should not take into account the amount of Q's, but % of Q's without answers

That is what you get from vague specs ;)

haha, pay peanuts get monkeys ;)

It is a bit at the end of my day and I have an office day tomorrow so it will have to wait till the weekend if you didn't get it resolved yourself before that.

ofcourse, no problem

Bedtijd ;)

@rene for bookmarking: data.stackexchange.com/interpersonal/query/1094971

my try at reworking