Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching through text - Speed issue
I was searching a list of 100 key words in a 1 million line text file. I used
two methods of looping the search: 1. I loop through all lines in the text file for each key word 2. I loop through all key words for each line in the text file Both ways search through 100 times 1 million lines. How come after many tests, the second method is about 30% faster than the first? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching through text - Speed issue
I would chance at guess at this:
1) You are hitting the disk 100 times to re-read the text file for each search (or, if you have read the entire text file into one humongous array, you are still hitting the disk multiple times due to the large array being swapped out in a system page file.) 2) You are reading the file once from beginning to end while checking against a very small array of search items entirely in local memory. That's about the best I can guess about system stuff. "J@Y" wrote: I was searching a list of 100 key words in a 1 million line text file. I used two methods of looping the search: 1. I loop through all lines in the text file for each key word 2. I loop through all key words for each line in the text file Both ways search through 100 times 1 million lines. How come after many tests, the second method is about 30% faster than the first? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed Issue | Excel Discussion (Misc queries) | |||
Speed Issue after updating cells | Excel Discussion (Misc queries) | |||
Speed issue with Multilple Web Queries | Excel Programming | |||
Calculation speed issue | Excel Discussion (Misc queries) | |||
Dynamic Ranges: Speed Issue | Excel Worksheet Functions |