Forum Discussion

iviglious's avatar
iviglious
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Odbc.Query triggering only one query

Currently the Odbc.Query function is triggering 2-4 identical queries against the source DB engine instead of just one. This is happening even after disabling all functionalities and lowering the se...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi iviglious ,
    Thank you for your detailed analysis.
    Since you have already raised a support ticket and closed, creating an idea and upvoting it to increase visibilty would be the next best approach. Thanks for doing that.
    Thanks for analyzing deeper into  (Value.NativeQuery(StarburstPresto.Contents) and confirming it generates two identical queries.
    While Table.Buffer is a workaround, we understand that it is not an ideal solution due to its impact on total processing time.

    Now that the idea is created, thank you for your patience as the issue is being addressed.

    Best Regards,
    Vinay.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi iviglious ,

We wanted to follow up and check if the solution provided addressed your needs. If so, kindly mark it as a solution to assist others. If you require further assistance, please don't hesitate to reach out.

Thank you!