Indexing time.

[HunterEC]

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.

Code: Select all

         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 ?

Code: Select all

         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.

[FranciscoA]

Try this, please

Code: Select all

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

[Patrizio]

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