>- see footer for list info -< You may not be maxing out the DB but Simons INTERSECT type suggestion is much better than using IN(), as on some databases you will find IN() has a limit so much better to not use a sub query unless you absolutely have to.
On 22 June 2010 14:48, Tom Chiverton <[email protected]> wrote: > >- see footer for list info -< > On Tuesday 22 Jun 2010 14:22:50 Simon Baynes wrote: > > You should do a left join and look for nulls as that as that is more > > performant than a not in sub-query! > > I find sub queries easier to read, and we're lucky enough to not be maxing > our > database out yet :-) > > -- > > Tom Chiverton > Developer > > [email protected] > 3 Hardman Square, Manchester, M3 3EB > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England and > Wales under registered number OC307980 whose registered office address is at > Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A > list of members is available for inspection at the registered office > together with a list of those non members who are referred to as partners. > We use the word “partner” to refer to a member of the LLP, or an employee > or consultant with equivalent standing and qualifications. Regulated by the > Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee you > must not read it and must not use any information contained in nor copy it > nor inform any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
