FiveTech Software tech support forums

Posted: **Mon Jun 23, 2014 12:54 am**

Guys:

When I create 9 tags on a CDX index on a 340MB dbf file without a meter the whole process takes 1 minute 2 seconds.

         INDEX ON &cKeyField TAG (cTagName) FOR &cForCond

If I execute the same command with a meter, it takes over 25 minutes. Why this humongous time difference ?

         INDEX ON &cKeyField TAG (cTagName) FOR &cForCond EVAL ( oMeter:Set( RecNo() ), SysRefresh(), ! lEnd )

Can anyone have a clue ?

FiveWin 13.09, xHarbour

Thank you very much.

Posted: **Mon Jun 23, 2014 2:03 am**

Try this, please

INDEX ON &cKeyField TAG (cTagName) FOR &cForCond EVAL ( oMeter:Set( RecNo() ), SysRefresh(), ! lEnd )  EVERY 80

Posted: **Mon Jun 23, 2014 2:46 pm**

The difference is the SysRefresh() function called a very large number of times.

Indexing time.