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.
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.