Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

JoomlaTune Support Forum    JComments component    Suggestions, Wishlists & Feature Requests    Topic: Votes Table is extremely Big
Pages: [1]   Go Down
  Print  
Author Topic: Votes Table is extremely Big  (Read 10124 times)
0 Members and 1 Guest are viewing this topic.
Masoud
Jr. Member
**

Karma: 0
Offline Offline

Posts: 46



« on: July 30, 2013, 21:46:41 »

I found the table _jcomments_votes which is contain IP and the Negative / Positive Value is extremely big. in my case it's about 200MB, but after some time we do not need to store who voted on the specific comment. I recommend you to add a Maintenance feature to summarize old votes and find a way to reduce the size of this table.

I mean keep the number of negative and positive votes of certain comment but remove the data about who voted on the comment.
Logged

----------------------
www.zoomit.ir
smart
Administrator
Hero Member
*****

Karma: 188
Offline Offline

Gender: Male
Posts: 1883



WWW
« Reply #1 on: July 31, 2013, 00:17:27 »

Yes, this is good idea! As temporary solution I can suggest simple SQL-query:

Code: (sql)
DELETE
FROM `jos_jcomments_votes`
WHERE `date` < DATE_SUB(NOW(), INTERVAL 1 YEAR);

It will remove detailed information about all votes older than 1 year. I mean only technical information like user ids and IP's.

Or we can remove for guests only:

Code: (sql)
DELETE
FROM `jos_jcomments_votes`
WHERE `date` < DATE_SUB(NOW(), INTERVAL 1 YEAR)
AND userid = 0;
Logged

If you use JComments, please post a rating and a review at the Joomla! Extensions Directory
Masoud
Jr. Member
**

Karma: 0
Offline Offline

Posts: 46



« Reply #2 on: July 31, 2013, 09:45:39 »

this is perfect thank you
Logged

----------------------
www.zoomit.ir
Pages: [1]   Go Up
  Print  
JoomlaTune Support Forum    JComments component    Suggestions, Wishlists & Feature Requests    Topic: Votes Table is extremely Big
 
Jump to: