WordPress.org

1. pilsschouler
   Member
   Posted 3 years ago #

   backed up data (having login problems for users) and noticed that 80%!!! of the data is this:
   INSERT INTO wp_options VALUES (67, 0, 'rss_0ff4b43bd116a9d8720d689c80e7dfd4'

   INSERT INTO wp_options VALUES (69, 0, 'rss_867bd5c64f85878d03a060509cd2f92c', 'Y', 1, 'O:9:"magpierss":19:{s:6:"parser";i:0;s:12:"current_item";a:0:{}

   eg. I believe it's getting the complete rss feed from each of the wordpress news links and installing it as part of the database!

   SURELY THIS IS NOT RIGHT AND GOOD?

   please advise!

2. podz
   Support Maven
   Posted 3 years ago #

   It does indeed get stored in the database.

3. pilsschouler
   Member
   Posted 3 years ago #

   but why?

4. Chris_K
   Administrator
   Posted 3 years ago #

   You'd rather those feeds were stored ... where?

5. podz
   Support Maven
   Posted 3 years ago #

   In comparison to the size of the database the space taken is very small. The other option is to remove the dash.

6. pilsschouler
   Member
   Posted 3 years ago #

   humour, though good in itself, is not, at this point, helpful. perhaps towards the conclusion?

   Meanwhile:

   Can one turn them off?

   Forgive me for being naive, but I thought the whole point of 'feeds' was to 'feed' neccessary content (eg.title / link / 1st line) not unneccessary (eg. the whole article/thread/site/post/whatever) into a database...

7. pilsschouler
   Member
   Posted 3 years ago #

   sorry was busy gently rebuking.

   'remove the dash' Could you be a little more precise, bearing in mind I'm not only 'naive' I'm a, a, a designer, there I said it.

8. pilsschouler
   Member
   Posted 3 years ago #

   ps. 107615 characters...is that very small?

9. Chris_K
   Administrator
   Posted 3 years ago #

   My post was not humor. At a guess, I theorize they are stored in the db to prevent those servers offering the feeds from being hammered every time someone goes to their dashboard. Maybe. I dunno.

   Personally, I don't find 100k very large in the grand scheme of things.

   Also personally, I find those feeds in my Dashboard (aka "the dash") often annoying. Here's a thread that addresses some options towards eliminating them.

   http://wordpress.org/support/topic/53586?replies=4

   You can also just manually remove the lines of code in /wp-admin/index.php if you'd like.

10. pilsschouler
    Member
    Posted 3 years ago #

    apologies! have seen other threads with less than helpful comments.

    this link looks excellent. I shall atempt and post results.

    A sincere thankyou and apology.

    :]

11. chiunam
    Member
    Posted 3 years ago #

    I got the same problem and it takes very large amount of my database.

    There are 2xxx records which are similar to pilsschouler's. I found that most of them are duplicated with same option_name & option_value. It took total about 3xMB of my DB!

    I am not sure what's going wrong and now I just delete those records and turn off the feed of dashboard. The database then becomes to less than 1MB :\

    It may be a bug of WP as i aslo found some duplicated options which probably come from other plugins but they are just very small amount compared with WP's feed.

    Hope this information could help the developers to solve the problems.

Topic Closed

This topic has been closed to new replies.