FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Indexing time.
HunterEC
Posts: 723
Joined: Tue Sep 04, 2007 08:45 AM
Indexing time.
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.
Code (fw): Select all Collapse
         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 (fw): Select all Collapse
         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
Posts: 2170
Joined: Fri Jul 18, 2008 01:24 AM
Re: Indexing time.
Posted: Mon Jun 23, 2014 02:03 AM
Try this, please
Code (fw): Select all Collapse
INDEX ON &cKeyField TAG (cTagName) FOR &cForCond EVAL ( oMeter:Set( RecNo() ), SysRefresh(), ! lEnd )  EVERY 80
Francisco J. Alegría P.

Chinandega, Nicaragua.



Fwxh-MySql-TMySql
Patrizio
Posts: 90
Joined: Wed Nov 07, 2007 08:56 AM
Re: Indexing time.
Posted: Mon Jun 23, 2014 02:46 PM

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

Continue the discussion

Static archive · New replies & topics via GitHub Discussions