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.