Forum Discussion
Advocate IIIPower Query Performance
Community Championlbendlin many thanks the picture is getting clearer. I can see the other perspective now.
So if I am querying a large tbl (let's say a 1M+ db tbl) exists in an inefficient SQL server , are you saying PQ will rather do the transformation faster (due to query folding aspect) than through native SQL query (poor db design) ? I am just scared that given PQ's poor performance aspect, I doubt whether it will do it faster (with query folding) than the non-indexd SQL server (inefficient server). I can take that and experiment against a non-indexd db large db table.
Even if that is true, must not one try to detrmine first how efficient/ineffcient the server is before deciding on native SQL or PQ (to Query folding to take place).
Super UserThat's not exactly what I am saying. I am saying that spooling can be a better option in such a scenario. Query folding would only make it worse, so you would need to suppress that, with Table.Buffer() for example.