If they're not already, you want indexes on es.person_id and e.id and on es.attribute
Put EXPLAIN before your query (in phpMyAdmin/MySQL CLI etc) and the result will show you what is being done - ie the number of rows queried, indexes used etc. On 12 August 2010 10:06, Brendan Brink <[email protected]> wrote: > thanks for that Berend, > > Yes I agree the code I am working with is very old :( > > select e.id,es.attribute from person e > INNER JOIN table2 es on es.person_id = e.id, > WHERE es.attibute = 'Blender' > > I am wanting to create multiple joins on the table2 (attribute) table > so that can find people who have multiple attributes... > > ie: > > Find people who have attribute 'blender' and attribute 'driver' > > with each attribute existing as a row in table2. > > On Thu, Aug 12, 2010 at 9:51 AM, Berend de Boer <[email protected]> wrote: >>>>>>> "Brendan" == Brendan Brink <[email protected]> writes: >> >> Brendan> Could you advise if you can see any issue / fix with the >> Brendan> queries i have recently been making? >> >> Can you first please write this with ansi join style? Your syntax has >> been obsolete for 25 years. >> >> After that it's much easier to spot problems. >> >> -- >> Cheers, >> >> Berend de Boer >> >> -- >> NZ PHP Users Group: http://groups.google.com/group/nzphpug >> To post, send email to [email protected] >> To unsubscribe, send email to >> [email protected] > > -- > Kind Regards, > > Brendan Brink > > SMS Marketing Consultant | Manager > Sell2Cell Ltd. > > 021 0246 1646 | [email protected] | www.sell2cell.co.nz > > > > > We provide customized, cost-effective SMS & Web Solutions > Need a website? Need to integrate text-messaging into your business > or website? Contact us today for a free no-obligation quote! > > VISIT OUR ASSOCIATED WEBSITES: textvouchers.com | textguru.co.nz > > WARNING This email contains information which is CONFIDENTIAL and may > be subject to LEGAL PRIVILEGE. If you are not the intended recipient, > you must not peruse, use, disseminate, distribute or copy the email or > attachments. If you have received this in error, please notify us > immediately by return email, facsimile, or telephone (call us > collect). > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] > -- Chris Hope The Electric Toolbox Ltd Email: [email protected] Web: www.electrictoolbox.com Phone: +64 9 522 9531 Mobile: +64 21 866 529 -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
