Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Faster way?

by jreades (Friar)
on Oct 07, 2000 at 00:36 UTC ( [id://35662]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://35662]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (6)
As of 2024-04-19 10:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found