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:
- 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.
- 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.
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:
Thank you.