>>>Yes, looks like it. All my efforts of optimizing the code led to decreasing the speed so far. Or it seems so.
>>
>>It's ulikely that you can speed up some complex code w/o first finding out where bottleneck is.
>
>Looking at the results of Coverage Profiler I see this line as one of the taking most time:
>The expressions match the index tag expression (except that we don't have index on iActive_Flag). The Load_Address may have records just added prior to this operation...
>
>This line takes an average time of 1 sec. to execute on 100 records sample.
>
>In the original code that was written as SELECT-SQL. I re-wrote as dbase command because I want to take buffered data into account as well. But may be for address I don't need to implement dbase. I need to re-think.

How many records do you have per cPointer_fk? Maybe SEEK(m.lcPatients_pk, ...) and LOCATE WHEN...FOR will be faster?