>>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.
If it's not broken, fix it until it is.
My Blog