Performance and subqueries

[RodrigoPuelma]

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.