If your filter is:
SET FILTER TO char3=thisform.combo1.value
Then I assume that char3 is a field in the table.
In this case, you should have an index with the expression char3. This will make both a filter and a query faster, if they use this field for a condition.
For more details, search the help file for "Rushmore Optimization".
Hilmar, vfp it is not designed very well,
and SET FILTER is optimizable
ONLY IF NONE INDEX IS ACTIVECREATE CURSOR BLA (char3 c(3))
FOR k=1 TO 1000000
APPEND BLANK
NEXT
INSERT INTO BLA VALUES('12')
INSERT INTO BLA VALUES('11')
INDEX ON char3 TAG IX_char3
? "Expected similar times"
SET EXACT OFF
SET FILTER TO char3='1'
CLEAR
T1=SECONDS()
SCAN
ENDSCAN
? char3,SECONDS()-T1,ORDER(),KEY()
SET ORDER TO
T1=SECONDS()
SCAN
ENDSCAN
? char3,SECONDS()-T1,ORDER(),KEY()
