TIP OF THE DAY! Speed up re-indexing your files

[Lerebours, Jose]

This might be applicable to those using *nix flavor
of filePro to a degree - Have not tested it with
windows version.

I've found that I can have my indexes rebuilt in less than
half the time if I 

1. Use nice   (man nice)
2. Index each index individually instead of all of them
   in a single dxmaint command

   Use dxmaint [filename] -r -e -o[INDEX]

   in lieu of 

   dxmaint [filename] -e -ra

The latter will index all indexes A-P sequentially.  The
first option gives you the option to open as many sessions
as you want and rebuild an index per session.  That said,
you can virtually rebuild all 16 indexes in the time that
it takes to rebuild 2 of them.

Of course, you could write a shell script to automate things
and even include qualifiers.  Heck, if you want to get technical,
look into using  `at` command (man at) and schedule them all to start
rebuilding at once or X minutes apart.


CAUTION:
- Never rebuild indexes while file is in use
- You stand a better chance of having a successful rebuild 
  if you remove lock files prior to starting rebuilding but
  not once you start



Happy Holidays to you all !!!!



--
Jose Lerebours
Principal Software Engineer
Eagle Global Logistics
1801 NW 82nd Avenue
Miami, FL 33126
Voice: (305) 594-0038 Ext 7556
Fax #: (305) 593-0431
eMail: Jose.Lerebours at eaglegl.com
http://www.eaglegl.com