Question How to reduce table size?

✦ Summarize Topic

How-to and Troubleshooting

Last Post by Asti 2 years ago

2 Posts

2 Users

0 Reactions

1,153 Views

RSS

Posts: 15

sugar76

Topic starter

Translate ▼

Jun 22, 2024 7:31 pm

(@sugar76)

Eminent Member

Joined: 2 years ago

[#8577]

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 2 years ago 2 times by sugar76

Topic Tags

reduce table size database optimization

1 Reply

Posts: 8208

Asti

Support

Translate ▼

Jun 25, 2024 1:24 pm

(@asti)

Illustrious Member

Joined: 8 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.