DB> I found my problem and why Mysql lock my table for a select. In DB> fact, mysql sometimes don't use the right index and so does a 'Table DB> sort' that lock my table. I modify the query to add USE INDEX DB> clause and now, all seems to work well ... I just need to test DB> during several days to be sure that's i'm right ..
JZ> Did you first try an ANALYZE TABLE to update the optimizer stats? Yes ... I'm still having problem in fact, my search query is faster but also lock my table. But it's just a select :( I'm doing TCP connections to mysql and not localhost, perhaps the problem is here ... The network is ok and my app server is linking with the mysql server over a 100Mb LAN. The network have been tested and tested and all is well. I've given a try to fulltext index, not really better in query time processing but indeces have gone bigger drasticully ... Now, i should give a try to InnoDb. And i 'll also try to split my MyISAM table into smaller ones ... Thanks to all 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
