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

2007-10-03 Thread Colin Guthrie
Martin Marques wrote: SELECT * FROM company WHERE id NOT IN (SELECT companyID FROM contacts); Not ideal as has been mentioned else where in this thread. Col -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2007-10-04 Thread Colin Guthrie
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 – Identifies performance bottlenecks such as the worst-performing stored

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

2007-11-08 Thread Colin Guthrie
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 – Identifies performance bottlenecks such as the worst-performing stored procedures,