Smartare förslag

[dlidstrom]

Kör i en IRegisteredObject

https://haacked.com/archive/2011/10/16/the-dangers-of-implementing-recurring-background-tasks-in-asp-net.aspx/

QueueBackgroundWorkItem

[dlidstrom]

Frågor:

WITH topwords AS(
SELECT
    count(*) AS count
    , rw.word_id
FROM
    result_word rw
GROUP BY
    rw.word_id
ORDER BY
    count DESC)
SELECT
    tw.count
    , w.text
FROM
    topwords tw
JOIN word w ON
    tw.word_id = w.word_id
WHERE
    length(w.TEXT) = 6
ORDER BY
    count DESC
    , TEXT
LIMIT 100;

SELECT
    COUNT(*) FILTER (
    WHERE q.result_date IS NULL) count_nulls
    ,
  COUNT(*) FILTER (
    WHERE q.result_date IS NOT NULL) count_not_nulls
FROM
    query q;