i-recommend-this
i-recommend-this copied to clipboard
Add MySQL index
Create an index (sortation) based on a field or combination of fields, this grows the DB in size but allows MySQL to SELECT a lot faster as it doesn't have to loop over the whole list now. It can then jump to the requested record much much faster as it now has an index (sorted list) for those fields.
ALTER TABLE (prefix) .wp_irecommendthis_votesADD UNIQUEpost_ip (post_id, ip);
that (executed after table creation and during the next update) would add an index where the post_id & ip combination is required to be a unique combo
Fixed in version 3.10.3