René's URL Explorer Experiment

Title: Caution using this in production - scheduled emails creates many long running queries · Issue #141 · d4software/QueryTree · GitHub

Open Graph Title: Caution using this in production - scheduled emails creates many long running queries · Issue #141 · d4software/QueryTree

X Title: Caution using this in production - scheduled emails creates many long running queries · Issue #141 · d4software/QueryTree

Description: I created a simple report based on a view. The view normally takes around 13secs with a select * from. When an email report is schedule, hangfire retries the job in the event of an exception. My db ground to a halt. Looking at the proces...

Open Graph Description: I created a simple report based on a view. The view normally takes around 13secs with a select * from. When an email report is schedule, hangfire retries the job in the event of an exception. My db...

X Description: I created a simple report based on a view. The view normally takes around 13secs with a select * from. When an email report is schedule, hangfire retries the job in the event of an exception. My db...

Opengraph URL: https://github.com/d4software/QueryTree/issues/141

X: @github

direct link

Domain: patch-diff.githubusercontent.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Caution using this in production - scheduled emails creates many long running queries","articleBody":"I created a simple report based on a view. The view normally takes around 13secs with a `select * from`. When an email report is schedule, hangfire retries the job in the event of an exception. My db ground to a halt. Looking at the processes, I see lots of queries being run (presumably by hangfire).\r\n\r\n![image](https://user-images.githubusercontent.com/5644228/193751230-46d82d74-86a1-4260-a3ec-770b0775cb33.png)\r\n\r\n\r\nI'm currently investigating the root cause of the email exception and also why the queries aren't being terminated on exception, but in the meantime, BE CAREFUL SCHEDULING AN EMAIL IN PRODUCTION ","author":{"url":"https://github.com/Recodify","@type":"Person","name":"Recodify"},"datePublished":"2022-10-04T06:37:45.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/141/QueryTree/issues/141"}

Links:

Viewport: width=device-width