thanks to all, the problem is now rectified, was an index issue. Appreciate the assistance.
Cheers brendan. On Thu, Aug 12, 2010 at 10:12 AM, Chris Hope <[email protected]> wrote: > 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] -- 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]
