This is a migrated thread and some comments may be shown as answers.

Filter values and actual query against the db

1 Answer 24 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Phil
Top achievements
Rank 2
Phil asked on 02 Mar 2011, 02:14 PM
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

1 Answer, 1 is accepted

Sort by
0
Phil
Top achievements
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
Tags
Grid
Asked by
Phil
Top achievements
Rank 2
Answers by
Phil
Top achievements
Rank 2
Share this question
or