Can help me how to use "explain select command" , can help to increase speed to Database? Thank you for your answer..:-)
Just put "EXPLAIN" infront of any select statement you have, and execute it on a console. It should give you a break down of time it takes to finish each action. And base on these information, you can create indices to greatly increase the performance of your queries.
Good article here: http://www.phpbuilder.com/columns/tim20010110.php3
