> 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.
How often is this query being executed? Why do you need to fetch all 30k
rows?
---------------------------------------------------------------------
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
