Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text search challenge...
Message
 
To
16/02/2003 21:10:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00753959
Message ID:
00753990
Views:
18
>Who can offer the most efficient (i.e. fastest) code to accomplish the following?
>
>I need to search 3,000 ascii text files spread among approximately 20 sub-dirs. The files might contain 200-300 lines, bu I only need to search the first 7 lines of each file for a short keyword that the user will enter into a textbox. I report all matches into a listbox.
>
>My current method opens the file for an ascii read, then "for x= 1 to 7" and use the ATC() function to look for a match on each read line. It works, but it's kinda slow, just becuase there are so many files.
>
>I will post my code when I get to work on Monday, and you can critique it.
>
>Thanks.

Why not indexing those 7 lines in a dbf for fast searching?
On query, only open files modified since the last directory scan...
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform