Tip : Check SQL Index Fragmentation

[barelist]

Just noticed while doing some spring cleaning in the site's database that a lot of our most used tables had 70% + fragmentation on their indexes.

Made sure to rebuild and reorganize all of them, and they're now sitting around 0-.1% fragmented.

Our DB is in SQL Server, but should apply to you MYSQL guys as well.

Pretty interesting that I believe our site is pretty optimized, but you can still stumble upon something like this

[Why]

optimization is never over.

[V_RocKs]

Optimize....

[barelist]

Then the host has a network issue... LOL

[jigg]

how do you do that on a wordpress without fucking up the db?

[HomerSimpson]

how do you do that on a wordpress without fucking up the db?

login at phpmyadmin -> select all database -> select all tables -> select optimize from drop down list -> confirm

you're done

[barelist]

login at phpmyadmin -> select all database -> select all tables -> select optimize from drop down list -> confirm

you're done

LOL, that makes it too easy