Jump to content


Photo

Reindex


  • Please log in to reply
3 replies to this topic

#1 argothor

argothor
  • Members
  • 25 posts
  • Gender:Male
  • Location:Arvada, CO
  • Interests:In no particular order - genealogy (after all this is a genealogy site), photography, hiking, alpine skiing and home brewing. <br /><br />Families I'm researching include - Baynes, Dellinger, Hartley, Humphreys, Keller, Moffatt, Nicodemus, Reed, Shigley, Spangler, Stipp, Strong, and others. <br />

Posted 15 April 2012 - 08:44 PM

If you click on File - Maintenance - Reindex, you get a message that reads: "This process may take several minutes. Index data now? Yes No". Not sure what this means, so I decided to look up what this is in the Help menu, which wasn't much help, for all it says is "The current project will be reindexed. Your data will remain intact."

So what does Reindexing do?

#2 Jim Byram

Jim Byram
  • Moderators
  • 6,697 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 16 April 2012 - 01:55 AM

Reindexing rebuilds the index files (.CDX) that are used to look up data in the data tables.

See: http://en.wikipedia..../Database_index

#3 argothor

argothor
  • Members
  • 25 posts
  • Gender:Male
  • Location:Arvada, CO
  • Interests:In no particular order - genealogy (after all this is a genealogy site), photography, hiking, alpine skiing and home brewing. <br /><br />Families I'm researching include - Baynes, Dellinger, Hartley, Humphreys, Keller, Moffatt, Nicodemus, Reed, Shigley, Spangler, Stipp, Strong, and others. <br />

Posted 18 April 2012 - 04:23 AM

When would you reindex your index files? Is it something you should do as a maintenance function to prevent problems or perhaps speed up searches, or only if there is some sort of error that needs to be addressed?

#4 Jim Byram

Jim Byram
  • Moderators
  • 6,697 posts
  • Gender:Male
  • Location:Framingham, MA

Posted 18 April 2012 - 06:04 AM

You only need to use the reindex function rarely when there is some data lookup issue.

Normal maintenance is: optimize, validate file integrity, optimize.

Optimize reindexes as necessary.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users