Hello.
It depends on the table's type. For MyISAM see:
http://dev.mysql.com/doc/mysql/en/optimize-table.html
For InnoDB:
http://dev.mysql.com/doc/mysql/en/innodb-file-defragmenting.html
Seena Blace <sqlserverdb@stripped> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 9 lines --]
>
> Hi,
> I have been noticing table performanace issue when # of rows grows more.How to tune
> that table?
> thanks
> -Seena
>
>
> ---------------------------------
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
