>>>Have tried to set the indexes off and the performance is still not acceptable.
>>
>>1. Give example of filter expression and example of index expression
>>
>>2. Do you have "SET DELE ON", if so do you have an index on "DELETED()"
>>
>>3. All indexes are CDX tags?
>
>Here's a little more about the problem. The table (we'll call it table1) contains 29,000 records and continues to grow. The field we are trying to filter on is a name field of 33 charters. From a small table(called table2) that was created from the unique names in table1 we select a name. We then try to set filter to the name in table1 this is the expression we use :'ALLTRIM(table2.name)=ALLTRIM(table1.name)' . We have tried this in the dataenvironment for table1 and also tried it from within the code with the 'SET FILTER TO' command. We have Deleted set on, but there is no index on 'DELETED()'. All the indexes are cdx tags.
>
>Thanks Anthony.
Firstly, I am sorry for interrupting. Secondly, filter expression is suspicious a Little bit, i.e. if you filter by ALLTRIM() you should have Tag on ALLTRIM() too, otherwise it's not optimizable. Moreover, good indexing for 29K recs should provide that SELECT-SQl into cursor will be fast enough.
Edward Pikman
Independent Consultant