Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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

by zakzebrowski (Curate)
on Oct 18, 2004 at 13:56 UTC ( #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
Node Status?
node history
Node Type: note [id://400145]
help
Chatterbox?
[prospect]: Hello, did anyone archived the video lessons from Randall L. Schwartz ? They where on youtube a few weeks aga but O'reilly Media took them down =(

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2017-09-25 10:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (279 votes). Check out past polls.

    Notices?