Technogearophilia

Whenever you create or edit an article in WordPress, the software suit will save multiple revision copies of the article. This is a waste of server and database resources. Excessive or extraneous revision records will increase the burden on the underlying database.

This will increase loop iterations, data retrieval, and page loading time.

Periodic deletion of these post revision and all their associated metadata should be considered part of your normal maintenance routine. This can be accomplished with a simple SQL statement:

DELETE a,b,c FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

NOTE: Depending on exactly how WordPress was installed, the table names (wp_posts, wp_term_relationships, & wp_postmeta) may need to be modified to include the blog name, e.g., wp_yourblogposts.

Despite the ongoing battle between the major players in the Social Media marketspace, there’s room for all of them because they’re not that similar to each other. They each cater to differing user needs.

What’s important is for the user base to determine which Social Media platform is the right Social Media for them.

Obviously, due to convergence, Twitter is and will continue to be the big winner in the Social Media wars because it can be used in conjunction with all the other offerings. It also seems to be the new weapon in the arsenal of the world’s revolutionaries.

Paul Butler, an intern at Facebook, made a map visualizing Facebook friendships. It is, as first glance, both interesting and compelling. Just by plotting Facebook users’ listed hometowns and mapping their online friendships Butler, who unsurprisingly is interning with Facebook’s data infrastructure engineering team, managed to create a map of the Earth and her cities just with a color ramp projection of those friendships.

Compare The Two Maps (Click to Enlarge)

It is interesting that Butler’s projection effectively drew the continents and even some national boundaries, but it’s not really surprising or a particularly great revelation.

Butler’s projection matches well with NASA’s light map of the Earth. That means it matches up well with regional population densities and technology levels, which shouldn’t be a shock to anyone.

In all likelihood, you could create the same map, or one damn close to it, by plotting the traffic to any set a major websites. The internet follows civilization and Facebook is part of the internet.