Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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 scrutinizing the Monastery: (4)
As of 2015-08-29 22:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (344 votes), past polls