how to know if locate is still work

[marcfree]

I have to use the locate command to find text in a memo field of a table with 50000 records and this search sometimes take a long time and I'd like to inform the user an evolution of the searching process (like a thermometer). How to do that?

Thanks for any help

 

[rgbean]

While I've seen techniques to show this kind of info, it can GREATLY slow down the search, so it's really not a good thing to attempt.

What are you searching for? Is there any way to 'index' the data, or reduce the number of records you have to actually LOCATE on?

Fifty thousand records is really not that much - is the network very busy? Are the file server or workstations 'underpowered'? (i.e. What kind of configurations are you using?)

Rick

 

[JRB-Bldr]

Assuming that you are not too concerned with over-all speed and still need to have a Progress Bar/Thermometer you might want to look at:

http://www.jjtc.com/Fox/foxfiles/

progress.zip
pcdone.zip

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com