Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Speeding up data lookups

by elwarren (Curate)
on Sep 19, 2005 at 20:00 UTC ( #493283=note: print w/ replies, xml ) Need Help??


in reply to Speeding up data lookups

Using a database (properly) will no doubt speed up your searches. The database is there to sort, index, and cache your information. Everyone has pretty much covered this already. The only performance penalty I see will depend on how often you need to load new shell files into the database and how long it takes to index them. It might not be the fastest solution if they are completely replaced by new files a few times a day. On the other hand, if you have time to load and index that 700mb file once, you'll see a big improvement in running reports against it...

HTH


Comment on Re: Speeding up data lookups

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2014-08-22 08:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (150 votes), past polls