Site Overlay
Jose M Castaneda

Random spring cleaning

Today I spent some time on the support forums answering some questions and just trying to help some people out.

I also cleaned things up a little bit on this site. The one thing I did was clear out random tables from the database and just tinkered with other things along the way. I was able to fiddle around with a little Drupal as well so that was really nice.

The one thing I liked was looking at metrics. Part of the reason is I like looking at numbers. The first thing I noticed was the size of the overall database. It was just under 7mb which really isn’t much when you think about it. I ran a few commands on them and they sort of helped. A little bit but not like super, crazy, insane good.

One thing I liked doing was running two queries. The first one to get all the posts because I wanted to see how fast it would be and now many there were as well. I ran:

SELECT * FROM wp_posts WHERE post_type = 'post';
/* Affected rows: 0  Found rows: 166  Warnings: 0  Duration for 1 query: 0.172 sec. (+ 0.312 sec. network) */

I found it pretty cool that I do have 165 posts on here. The other cool part is that it was able to retrieve all of those in well under a second. Now granted that is how many databases are and function as well. Pretty quick when doing those directly.

The one part I was happy about was being able to reduce the size a little because I realized that there were a few tables from plugins I no longer used and some rows that were also removed that I know I won’t be using ever again. Many of those were just widget settings from random themes I had tested on here.

Did I need to do that? Not really. It was mostly because I wanted to practice things. It really has been way too long since I’ve even done anything like that. I’ve been enjoying that since that’s what I spent most of my day on.

The other thing was tinkering with JavaScript and some JSON responses. I was having some fun with the WordPress api and just getting some things to actually render properly on the page. Not using any external libraries as well so that was pretty fun to do.

I have a post right now in draft that actually does go a bit more into frameworks too. Or at least the ones I’ve read some documents of and have tried. This is the part where I just say if there were more hours in the day I would be able to explore all of them.

Hopefully I can look over more things next week.

Published By:

Author: Jose

Born in El Salvador. Loves to read, write, draw, paint, build, test, typography, hike, photography, art, design, sewing, and many other things.

Leave a Reply

Your email address will not be published. Required fields are marked *

You are limited to 500 words

If you do not see your comment in the next 24 hours, please email jose[at]josemcastaneda[dot]com

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Some things were said, some code was broken. Proudly powered by WordPress