inline-query icon indicating copy to clipboard operation
inline-query copied to clipboard

Published 20 hours ago • verified publisher icon msnraju

Performance and subqueries

Open RodrigoPuelma opened this issue 3 years ago • 0 comments

I am currently running 2 Query objects to retrieve a combined result. I was thinking of replacing them with one call with the inline query. I have 2 questions:

  1. In the MS Journal blog information under "Limitations / Disadvantages" it is stated that "It compiles the Query Text every time before executing. This is not good for performance.". How much of an impact is does the compilation have? I am trying to compare with 2 Query objects calling the same table with different subqueries.
  2. Can I do subqueries? I am trying to combine the 2 Query objects I am running today into one select query containing 2 subqueries.

Thank you.

RodrigoPuelma avatar Nov 16 '21 23:11 RodrigoPuelma