RE: FN-FORUM: MySQL Query Problems

date posted 31st January 2006 12:48

ashley etchell wrote:
>
> A join gives the opposite but you could run over the
> resulting array in php
> or whatever and eliminate results, im a big believer in
> pushing as much work
> to the parsing engine if the operation can be done that way
> as opposed to
> using the DB,

That might be okay for small datasets but doing a foreach loop for a large
result set could be very slow and very processor/memory intensive. Database
engines tend to be written for manipulating data and not much else and I'd
be surprised if interpreted PHP could get anywhere near.

Karl