Is this module suitable for people that know little or nothing about databases? I know just about nothing, I simply want my site to run faster.

Is using the index feature for all items in the "Indexes for Views" and "Indexes for Core modules" safe? Or, should this feature only be used by people that know their stuff when it comes to databases?

Comments

mikeytown2’s picture

mikeytown2 commented

Indexes are fairly safe. The other tabs; you should be comfortable with phpmyadmin at a minimum otherwise I don't recommend using those. I would start with "Indexes for Views" and go from there.

crea’s picture

crea commented

It should be noted on project page, that mindless using of indexes can actually slow your database, not speed up. Every index slows write operations. This is especially true for shared hosting, where disks are oversold and disk IO is expensive.

crea’s picture

crea commented
Status: Active » Closed (duplicate)

Duplicate of #1218556: Disclaimer on adding indexes and performance drop