Best practices for using MySQL index

From: Date: Wed, 30 Apr 2008 04:54:04 +0000
Subject: Best practices for using MySQL index
Groups: php.db php.general 
Request: Send a blank email to php-db+get-44926@lists.php.net to get a copy of this message
Hi all, I am currently responsible for a subscription module and need to design the DB tables and write code. I have described my table design and queries in the post: http://phparch.cn/index.php/mysql/38-MySQL-configuration/152-best-practices-for-using-mysql-index The problem is, in a short time the table will hold millions of records. So the query and index optimization is very important. Any suggestion will be greatly appreciated. -- Regards, Shelley

« previous php.db (#44926) next »