[PHP] RE: [PHP-DB] Re: MySQL Identifying worst-performing codes

2007-10-05 Thread Lasitha Alawatta
B] Re: MySQL Identifying worst-performing codes Lasitha Alawatta wrote: > There is a tool call “idera” (SQL diagnostic manager). Basically it is > a performance monitoring and diagnostics tool. > > It has a feature; > > > > Identifying of worst-performing codes

[PHP] MySQL Identifying worst-performing codes

2007-10-04 Thread Lasitha Alawatta
Hello friends, There is a tool call "idera" (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures, long-ru

[PHP] RE: [PHP-DB] the opposite of a join?

2007-10-03 Thread Lasitha Alawatta
Hi J, Checkout this, SELECT * FROM tbl_company where id not in (SELECT companyID from tbl_contacts) Regards, Lasitha Alawatta Application Developer Destinations of the World Holding Establishment P O Box: 19950 Dubai, United Arab Emirates ( Ph +971 4 295 8510 (Board) / 1464 (Ext.) 7