I've found that Solr running on modest hardware (a 2.4 GHz PC running
Windows XP Pro for testing changes) is able to index about 23,000
records in under three minutes. Assuming you aren't going to make too
many typos in your naming, you should be fine just doing the
re-indexing. Try timing yo
Short answer: It depends.
Long answer: It depends on whether you want to be able to search on.
If you need to search by recruiter name then obviously you'll need to
index it, if you don't you only really need to index the most relevent
db identifier, then work out the relations from that in MySQL (