[Datamart-News] Long running queries

[WALLACE Aaron * DAS]

Datamart users,

Just a friendly reminder that we must be aware of how long our queries run. We only have one server to handle all state queries.

The key is to remember that most queries run in under 15 minutes. Unless you are pulling data from a large agency (Ex. DHS, DOC, OHA) and you are pulling multiple years' worth of data, the query should run quick. Make sure to stop a query that is running longer than expected.

We appreciate your understanding.
Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230615/2a355a18/attachment.html>