BS> Have you tried the command : "EXPLAIN SELECT select_options" BS> (http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see BS> what Indexes are used ...
Yep i do that but varchar and text fields aren't index so ... I'm also having a look to FULLTEXT index, but i think that the index will be really really big ... :( I'm also reading docs about locking. In fact i saw while using show full processlist that when mysql is executing the query, all other ones are 'locked' but why lock table for a SELECT query ? And that's a good question. I surely missed something about the lock statement ... David --------------------------------------------------------------------- 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
