to all, warm regards from brazil.
here's the plot: my isp has been complaining
for last couple of days about this query,
generated automatically by a query generator
(no, duh??)...
SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
LIKE "%%" OR email LIKE "%%" OR ativo LIKE "%%" ORDER BY nome;
Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
before anyone jumps out and points it out, it is far
from being optimized. it should (and will, as soon as
i update the generator) read:
select * from listaemail order by nome;
my question is: could there possibly be a problem in
the execution of such a query???
my isp's system administrator states
this query is causing the server to become "unstable".
i firmly believe there is no harm in executing such
query, even if it's not optimal.
any insights will be greatly appreciated.
kindest regards,
mauricio portasio
[EMAIL PROTECTED]
sao paulo - brazil
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php