Hi,
Isn't there a way to reduce the number of rows that are scanned based on an
index - for example
the query
SELECT * FROM email WHERE id>100 AND subject = 'RE: TEST EMAIL' ORDER BY
`id` DESC LIMIT 0,25;
will be significantly faster (it will scan less rows) and will most probably
return the
What version MySQL are you using? Did you set up the MySQL server?
SQL_BIG_SELECTS is to prevent users from making 'foolish' queries'
"SQL_BIG_SELECTS = 0 | 1
If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. This is useful when an inadvisable WHERE s