Best practices for using MySQL index

------=_Part_20186_23780803.1209531244705
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_20186_23780803.1209531244705--
skylark [ Mi, 30 April 2008 06:54 ] [ ID #1950450 ]
PHP » gmane.comp.php.database » Best practices for using MySQL index

Vorheriges Thema: Query
Nächstes Thema: fourat wants to keep up with you on Twitter