WordPress.org

1. brockangelo
   Member
   Posted 5 years ago #

   I have been working on speeding up my site found here: http://www.brockangelo.com

   When I was a WP newbie, I installed everything on the planet to see what all WP can do. What I did not know is that each of these things will add code to the database - good and possibly bad. My hunch is that I have a database that has way more info than I need in it, so I have started to delete all the useless scripts that I no longer need. I've already cut the database in half.

   Two questions: does anyone know where to find what is written to the database on a fresh install? (so that I can more strategically go about deleting the rest)
   And, has anyone else done this and found a significant difference in the speed of the site?

   I've used the site diagnostic tool at websiteoptimization.com and it did not appear that I could implement much of the recommendations, so I'm trying the db approach. Any feedback on the project would be appreciated.

2. Kafkaesqui
   Moderator
   Posted 5 years ago #

   Take a look at the source of upgrade-schema.php in the wp-admin/ directory. If you can read it, you'll find the 1. tables that WordPress creates, and 2. options (in the options table) you should consider default.

   As for feedback, I'd only recommend you do this with a great deal of caution. Back up your db first, and triple-check any record before permanently whacking it.

3. brockangelo
   Member
   Posted 5 years ago #

   Awesome. This helps a lot. I had a couple of tables in there from installing ShortStat. After deleting these, I'm seeing a difference in load time already.

   I have over 375 items in my wp_options table, and I know that a lot of these are unused. I'll start work on that too.

   Thanks a lot - I will mark this as resolved.

Topic Closed

This topic has been closed to new replies.