[SugarDog]

I don't see how you can cap the size of the queue. Is there an option to set the number of items or the length of time items are queued before deleting them?

I now have over 5,000 queued items, and I think that may be slowing performance of the site. I would like to automatically delete items that do not get published.

I'm using Pligg 9, DigitalNature, on a DreamHost account. Here's the site:

http://helpthing.com/

Thanks.

[kbeeveer46]

Create a php file and put this in it and run it as a cron job. It will delete any discarded stories and any unpublished stories after 14 days. Make sure to enter your database details.

<?php

mysql_connect("dbhost", "dbname", "dbpass") or die("error1");
mysql_select_db("dbname") or die("error2");

$fourteen_days   = 1209600;
$now = date("U") - $fourteen_days; 

$now = date("Y-m-d H:i:s",$now);

mysql_query("delete from links where link_date < '$now' AND link_status = 'queued'");
mysql_query("delete from links where link_status = 'discard'");

?>

[Daniel]

Guys, you are doing mistake by deleting unpublished stories after 14 days. It's better to have more content on your site so search engines can crawl more links...

*just a thought*

[kbeeveer46]

Daniel, some people have limitations on their database size set by their hosting company so they have to delete stories or they will run out of space. It should take a long time before this happens, though. Also, some people really don't care about Google page rank or being index.

[SugarDog]

Generally, I agree regarding the neverending database. I'd prefer it that way. However, I've been suspecting that some of my performance issues were related to the queue, and I wanted to do some tests around that.

[jitgos]

There are some pligg sites with pretty massive content that seem to run just fine, but it probably varies by host. Please let us know the results. I'm very interested.

[Daniel]

Originally Posted by kbeeveer46

Daniel, some people have limitations on their database size set by their hosting company so they have to delete stories or they will run out of space. It should take a long time before this happens, though. Also, some people really don't care about Google page rank or being index.

True. But instead of deleting queque, why not just archive it?

[davemackey]

This could be a cool feature to have? The ability to archive/delete stories that meet certain parameters from the admin. For example:
- Stories never voted on after x days.
- Discarded stories after x days.
David.