- Log in to post comments
User bio
404 bio not found
Member since Oct 3, 2019
Posts:
Replies:
Hi Kyle
Excellent article. I especially like the generic table reference to illustrate that the optimizer sees Table1, Table2,...field1, field2... instead of obvious index choices.
One recommendation for improvement is to explicitly call out Query Plan review. Its implied that query plans should be reviewed. I would call it out explicitly. I've seen instances where Tune Table is run without improving query performance (to much dissatisfaction and disappointment) .
When investigating slow performance - review query plans. Based on your understanding of the table and its indices, do you think the query plan is correct? Sometimes revision to WHERE clause search arguments is all that's needed (Query Tuning). Other times the "big gun" TUNE TABLE is required.
Thanks again for an excellent article.
dave L
- Log in to post comments
I got something working using logic like this.....
set RunStatus=$System.Status.Error(83,"DXL Testing Run Error")
set RunStatus=$System.Status.Error(5001,"DXL Testing Run Error")
- Log in to post comments
Certifications & Credly badges:
David has no Certifications & Credly badges yet.
Followers:
David has no followers yet.
Following:
David has not followed anybody yet.
Thank you for the quick reply.
For Clarity....
I should create an OnPreHTTP( ) method that tests my parameter and set the ContentType accordingly.
Pseudo code...
OnPreHTTP() as %Boolean
{
set pdfToken=$get(%request.Data("pdfToken",1))
if (pdfToken is valid) set set %response.ContentType="application/pdf"
else set %response.ContentType="text/plain"
quit 1
}