Timeline for How can one see when a query was cached in SEDE?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 21 at 16:01 | history | edited | Aaron BertrandStaff | CC BY-SA 4.0 |
Sorry I inadvertently forked the original query for recent SEDE refresh
|
| Apr 20 at 4:17 | comment | added | starball | querying PostHistory is probably better than Posts if you just want to pick up any "sign of life". It'll include community bumps, so even if the site is super dead, I assume there's still a better chance it'll have some movement every SEDE refresh. | |
| Apr 19 at 21:52 | comment | added | Franck Dernoncourt | @AaronBertrand thanks, interesting. I'll let you know if that happens again. The two queries were data.stackexchange.com/stackoverflow/query/540572/… and data.stackexchange.com/stackoverflow/query/851061/… I was mostly looking at the first query. Are SEDE results cached on client side, or solely on server side?. | |
| Apr 19 at 21:41 | history | edited | Aaron BertrandStaff | CC BY-SA 4.0 |
added 11 characters in body
|
| Apr 19 at 21:33 | comment | added | Franck Dernoncourt | Got it, thanks very much! Fyi not important but just to let you know, I believe that some cached plans and queries were cleared out only yesterday instead of last Sunday, based on 2 queries I've tried and my admittedly imperfect memory. (The 2 queries were returning cache results from the Sunday, April 7 refresh instead of the Sunday, April 14. They only returned the updated results corresponding to the Sunday, April 14 refresh since yesterday.) | |
| Apr 19 at 21:27 | vote | accept | Franck Dernoncourt | ||
| Apr 19 at 15:28 | comment | added | rene Mod | Note that users don't have to run a query as the home page of SEDE shows when the data was refreshed. I have a pending PR on that: meta.stackexchange.com/a/354134 but that rightfully didn't get merged. I think using the new view is preferred in that view (and address the performance / caching due to being run on the homepage). | |
| Apr 19 at 14:30 | history | edited | Aaron BertrandStaff | CC BY-SA 4.0 |
added 43 characters in body
|
| Apr 19 at 13:53 | history | edited | Aaron BertrandStaff | CC BY-SA 4.0 |
Slight adjustment to query (removed ugly COLLATE)
|
| Apr 19 at 13:42 | history | edited | Aaron BertrandStaff | CC BY-SA 4.0 |
deleted 9 characters in body
|
| Apr 19 at 13:36 | history | answered | Aaron BertrandStaff | CC BY-SA 4.0 |