Remove WordPress Revisions and PostMeta
Speeding up WordPress
More like cleaning up WordPress, but anyway. I see this code all the time and I use it,but I can see how some people may get confused by it. So I am going to try and tell you how to modify it for your own WP database.
The code below is pretty simple, but you cannot just copy and paste for it to work. You will need to be using PHPMyAdmin which you normally get from your hosting provider. Once inside here find your database on the left hand side and look for your WordPress tables.
Normally your tables will look something like wp_posts, but if you are a little more secure then you will have changed the prefix wp to something else.
The PREFIX is in red, make sure you change the red code below to your prefix.
DELETE a, b, c FROM prefix_posts a LEFT JOIN prefix_term_relationships b ON a.ID = b.object_id LEFT JOIN prefix_postmeta c ON a.ID = c.post_id WHERE a.post_type = 'revision'
Photo Source: http://www.flickr.com/photos/nbachiyski/ / CC BY 2.0
Google Fiber – Think Big with a Gig
1 Gigabit per Second
Google is planning to launch an experiment that we hope will make Internet access better and faster for everyone. We plan to test ultra-high speed broadband networks in one or more trial locations across the country. Our networks will deliver Internet speeds more than 100 times faster than what most Americans have access to today, over 1 gigabit per second, fiber-to-the-home connections. We’ll offer service at a competitive price to at least 50,000 and potentially up to 500,000 people.
From now until March 26th, we’re asking interested municipalities to provide us with information about their communities through a Request for information (RFI), which we’ll use to determine where to build our network.
Consulting
As you may know already, my 9 to 5 job is a consultant (don’t laugh at the site, it’s not done yet!), but what you may not know is that most of my clients are municipalities or somehow part of the government. I even work for a wonderful Mayor who is a woman. By watching the video below it seems that governments will get the first go at it and we are sending our RFI now.
Not just for Governments
G has mentioned that they will be offering this “trial” service to at least 50,000 people and potentially 500,000. If you check out their site here, you can fill out a Request for Information for your community as well.
Good Luck!
Monitoring Tsunamis and Earthquakes
Since I moved to Costa Rica I have been paying more attention to earthquakes, even ones that are not here. Early this morning an 8.8 magnitude earthquake hit Chile and now the US government has issued a tsunami warning to Costa Rica, Panama, Colombia, Ecuador and Antarctica.
Monitoring Tsunamis
I already wrote about monitoring earthquakes and now I will tell you where you can monitor tsunamis, which happen when an earthquakes center is in the ocean.
So if you heard there was an earthquake in the ocean and you want to know if a tsunami is on the way, just go here;
NOAA Pacific Tsunami Warning Center
Photo Source: http://www.flickr.com/photos/epugachev/ / CC BY 2.0
