Hi:
I am creating a filtered grid and I am concerned about performance. My default query against the table has a top 200 attribute. I went into 'Sql Query Profiler' and the filter did not appear. So, are you only applying the filter against the output dataset? In which case the top 200 will not work. How can I have the actual db query limited?
Phil
I am creating a filtered grid and I am concerned about performance. My default query against the table has a top 200 attribute. I went into 'Sql Query Profiler' and the filter did not appear. So, are you only applying the filter against the output dataset? In which case the top 200 will not work. How can I have the actual db query limited?
Phil
1 Answer, 1 is accepted
0
Phil
Top achievements
Rank 2
Rank 2
answered on 06 Mar 2011, 09:06 PM
It is like DefaultView, bad idea to do a top 200. I ended up using NeedData event and rebinding upon a filter event.
Phil
Phil