>The SET FILTER command is actually affects the performance of my application. >We usually filter by location, from Region downto Barangay, then by >implementing agency, funding agency, etc... It has a lot of fields to filter >when we are updating our data, we implement these for fast updating and >retrieval of data... Evrytime I change the filter expression, the performace >is also degrading....

You will probally get better results to use SQL to grab a subset of records, make sure the expression you use is optimized.

Bob