Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: Basic Perl array intersection faster than mysql query join.

by zakzebrowski (Curate)
on Oct 18, 2004 at 13:56 UTC ( [id://400145]=note: print w/replies, xml ) Need Help??


in reply to Re: Basic Perl array intersection faster than mysql query join.
in thread Basic Perl array intersection faster than mysql query join.

Also, speed isn't the only thing to consider... If you are ever going to alter the tables or multiple table joins, or try to add full text indexing, or try to do something more complicated, a database will help you. Using a database versus using a (insert language here) script to do what you need to do, is a tradeoff between speed, maintainability, and east of expandibility... If, though, you know that all you will be ever doing is joining those two tables, and you are ready to deal with the risk of doing the join in the code base, and you need the speed, go for it.


----
Zak - the office
  • Comment on Re^2: Basic Perl array intersection faster than mysql query join.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2024-04-18 07:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found