D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed.
As soon as I enabled the option 'log_queries_not_using_indexes = 1' in
the configuration file, I started getting messages relating to the
select query:
SELECT wite_what, wite_desc FROM witelist
WHERE
wite_what = '$oct1' OR
wite_what = '$oct1.$oct2' OR
wite_what = '$oct1.$oct2.$oct3' OR
wite_what = '$oct1.$oct2.$oct3.$oct4' OR
wite_what = '[EMAIL PROTECTED]' OR
wite_what = '[EMAIL PROTECTED]' OR
wite_what = '$from_dom' OR
wite_what = '$rcpt_dom';
did you tried (result depending on your MySQL version):
WHERE wite_what IN ('$oct1', '$oct1.$oct2', '$oct1.$oct2.$oct3',
'$oct1.$oct2.$oct3.$oct4', '[EMAIL PROTECTED]',
'[EMAIL PROTECTED]', '$from_dom', '$rcpt_dom');
you could also vary with thee index length if wite_what.
and what indexes do you have currently exactly?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
