Question How to reduce table size?

How-to and Troubleshooting

Last Post by Asti 2 months ago

2 Posts

2 Users

0 Reactions

190 Views

RSS

Posts: 11

sugar76

Topic starter

Jun 22, 2024 3:31 pm

(@sugar76)

Eminent Member

Joined: 12 months ago

First of all, I'd like to thank the wpdiscuz team for providing this excellent plugin 🙂

We noticed that the table wc_users_voted, which is active since 8 months, has currently 400 MB of size and is constantly growing.

Are there any possible optimizations to reduce the growth speed of this table or other ways to reduce size?

I checked the wpdiscuz settings but didn't find anything about reducing database size.

E.g. is it possible to disable voting for posts which are more than X days old?

Website URL

https://apollo-news.net

This topic was modified 3 months ago 2 times by sugar76

Topic Tags

vote database

1 Reply

Posts: 7445

Asti

Support

Jun 25, 2024 9:24 am

(@asti)

Illustrious Member

Joined: 7 years ago

The wpDiscuz plugin doesn't have such functionality.

However, you can truncate the data in the table. This will not affect the voting count. The data is stored there to prevent the same person from voting for the same comment multiple times.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.