Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Fast seeking in a large array of hashes to generate a report.

by Tanalis (Curate)
on Jun 23, 2005 at 07:20 UTC ( #469307=note: print w/ replies, xml ) Need Help??


in reply to Fast seeking in a large array of hashes to generate a report.

If you're populating the dataset from a database, then restricting that dataset from a config file, why not simply generate some SQL to restrict the dataset you're downloading from the DB in the first place?

The database can almost certainly perform this search-and-restrict quicker server-side than you can by downloading all data and then restricting what you display.

Edited for clarity.


Comment on Re: Fast seeking in a large array of hashes to generate a report.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2014-09-15 10:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (146 votes), past polls