in reply to Faster way?
With what sort of frequency are the files updated -- is it worth stuffing matches into a database and expiring them every couple of days?
Are matches unique, or multiple? (I think the later, but this isnt' spelled out)
Depending on the frequency of modification, you could use a table setup something like the following:
| files | matches |
| file_id UNIQUE INT path UNIQUE VARCHAR/TEXT last_access-stat TIME |
word VARCHAR file_id INT position INT |
This is just an off-the-cuff format, nothing to run a db by...
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
| A reply falls below the community's threshold of quality. You may see it by logging in. |