I agree with this. Never use a subquery when a join will work. The
optimizer with thank you with performance.
James Ausmus wrote:
On 10/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi J,
Checkout this,
SELECT * FROM tbl_company where id not in (SELECT companyID from
tbl_contacts)
Does the data change often? If not you could just enable query cache and
cache connection threads and you'd probably be fine.
Dan wrote:
After thinking about this a while I also thought of making my own
cache. The problem with that is would it be any faster or have any
less strain on the serve
he got a ddos attack from writing to the list ;)
On Fri, 20 Jul 2007 3:33 pm, Daniel Brown wrote:
On 7/20/07, Austin Denyer <[EMAIL PROTECTED]> wrote:
Daniel Brown wrote:
On 7/20/07, Sascha Braun, CEO @ ejackup.com <[EMAIL PROTECTED]>
wrote:
Today I was writing an E-Mail here in the List
s
3 matches
Mail list logo
