The problem is, that i can't prevent queries like SELECT * FROM <TABLE> WHERE <COLUMN> LIKE 'a%' where an index will not help on a Table > 100.000.000 records. It's not that we have to answer hese queries (therefore the timeout), but it's impossible to prevent dumm users.
Run EXPLAIN on the untrusted queries first before executing them or set max_join_size low enough.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
