Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Comment / Trackback spams slow entire blog #1633

Closed
inureyes opened this issue Feb 3, 2014 · 1 comment
Closed

Comment / Trackback spams slow entire blog #1633

inureyes opened this issue Feb 3, 2014 · 1 comment
Assignees
@inureyes
Labels
enhancement major new
Milestone
1.10

Comments

@inureyes
Copy link
Member

inureyes commented Feb 3, 2014

Summary

  • Currently, spams are marked with 'isfiltered' flag, however they share the same table with comments / trackbacks. They are kept for the anti-spam plugins.
  • Massive spams weight the comment / remoteresponse table.
  • Two approaches
    • Shorter the auto-wipe period.
    • Divide comment/trackback and spam storage table.
@inureyes
Copy link
Member Author

inureyes commented Feb 7, 2014

Table TrashComments duplicates Comments
Table TrashRemoteResponse duplicates RemoteResponse

@inureyes inureyes self-assigned this Feb 7, 2014
inureyes added a commit that referenced this issue Feb 7, 2014
@inureyes
refs #1633 : implements table schema / setup for trashes
e0e17af 
 - Installation SQL for trash tables.
 - Table check routine in setup.php
inureyes added a commit that referenced this issue Feb 9, 2014
@inureyes
refs #1633 : implements table schema / setup for trashes
4d15892 
 - Installation SQL for trash tables.
 - Table check routine in setup.php
inureyes added a commit that referenced this issue Feb 9, 2014
@inureyes
refs #1633 : implement - added customizable trash keeping period
7fe6b94 
 - $service['trashtimelimit'] determines keeping period of trash
 comments / trackbacks
 - Default value is 3.5 days. (originally it was 15 days without any
	 option)
 - Checking interval is changed from 86400sec. to 43200sec.
 - Codebase of function trashVan() is changed from 1.7/8 to 2.0 codebase.
inureyes added a commit that referenced this issue Feb 9, 2014
@inureyes
refs #1633 : added - trash clean routine in checkup process
e46646c
inureyes added a commit that referenced this issue Feb 10, 2014
@inureyes
refs #1633 : bugfix - checkup cannot load trash-related methods.
7a2af3f
inureyes added a commit that referenced this issue Feb 10, 2014
@inureyes
refs #1633 : implement - comment trash handling functions.
3718402 
 - TODO: rewrite inefficient actions
 - TODO: check the maxId confliction. (it cannot be conserved now.)
 - TODO: view trash commment /trackbacks at admin panel. (not working
	 now.)
inureyes added a commit that referenced this issue Feb 10, 2014
@inureyes
refs #1633 : added - trash clean routine in checkup process
db800b5
inureyes added a commit that referenced this issue Feb 10, 2014
@inureyes
refs #1633 : bugfix - checkup cannot load trash-related methods.
36dbf37
@inureyes inureyes modified the milestones: 1.9.1, 1.9.0, 1.9.2 Feb 27, 2014
inureyes added a commit that referenced this issue Mar 6, 2014
@inureyes
refs #1633 : bugfix - missing bracket.
4563426 
 -
@inureyes inureyes modified the milestones: 1.10, 1.9.2 Mar 18, 2014
inureyes added a commit that referenced this issue Sep 16, 2014
@inureyes
refs #1633 : bugfix - DBModel now supports multiple condition for same
e97141b 
 field.

 -
inureyes added a commit that referenced this issue Sep 16, 2014
@inureyes
refs #1633 : bugfix - DBModel now supports multiple condition for same
b06af45 
 field.

 -
@inureyes inureyes closed this as completed Dec 9, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@inureyes inureyes

Labels
enhancement major new
Projects
None yet
Milestone
1.10
Development

No branches or pull requests
1 participant
@inureyes