Developer Tools > Optimization [PRO]

Although WP ULike’s performance has been greatly optimized using advanced algorithms to date, and all queries have an optimal structure, this does not diminish the importance of database optimization.

If you check your database, you will see the 5 tables listed below which has been created by the WP ULike plugin:

• wp_ulike – Stores post types logs
• wp_ulike_comments – Stores comments logs
• wp_ulike_activities – Stores BuddyPress logs
• wp_ulike_forums – Stores bbPress logs
• wp_ulike_meta – Stores meta-information about counters, stats, user status, etc.

All of these tables have their own specific structure and store various information such as user_id, user_ip, status, date_time, etc.

Optimize Database Tables

In this panel, you can manage your database tables with just one click.

Posts

1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike table)
2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "posts" group name.)
4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
   
5. Optimize Table Overhead: Overhead is a temporary disk space that is used by your database to store queries. Over time, a table’s overhead will increase.
6. Migrate Counter Metadata: You are about to migrate counter values to the WordPress "wp_postmeta" table.
7. Reset Counter Values: Reset all counters without affecting stats information.

Comments

1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike_comments table)
2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "comments" group name.)
4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
5. Optimize Table Overhead: Overhead is a temporary disk space that is used by your database to store queries. Over time, a table’s overhead will increase.
6. Migrate Counter Metadata: You are about to migrate counter values to the WordPress "wp_commentmeta" table.
7. Reset Counter Values: Reset all counters without affecting stats information.

BuddyPress

1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike_activities table)
2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "activity" group name.)
4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
5. Optimize Table Overhead: Overhead is a temporary disk space that is used by your database to store queries. Over time, a table’s overhead will increase.
6. Reset Counter Values: Reset all counters without affecting stats information.

bbPress

1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike_forums table)
2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "topic" group name.)
4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
5. Reset Counter Values: Reset all counters without affecting stats information.

Warning: All options in this panel work directly on optimizing and modifying database table rows. It is best to have a backup before doing anything.