[clue-tech] PHP/MySQL question

[Angelo Bertolli]

Greg Knaddison wrote:

>On 9/22/05, Matt Gushee <matt at gushee.net> wrote:
>  
>
>>On the face of it, the above query seems like the best solution. Is
>>there any reason to think it would be a bad idea, or that doing the
>>sort-and-limit in PHP would be better?
>>    
>>
>
>I have mostly done web applications using ColdFusion and either Oracle
>or SQL Server, though I have done a bit of ASP and PHP and MySQL.
>
>That said, I've never encountered a situation where the web language
>was faster than the database.  Sometimes they've been equal in speed,
>but the language hasn't been faster than the pl/sql.  I'm sure you
>could find examples where that's not true, but if you tune both, I
>think the pl/sql will win.
>  
>
I agree.  If speed is your goal, the database will usually, if not 
always, be faster than retrieving extra information plus filtering that 
information.  And it's not just because you're doing a little extra 
work, but also because that's what database systems are designed to do.

_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech