>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
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'