WordPress SEO – Optimize Post Title Tags In Your WordPress Theme

According to Wikipedia, WordPress was used on more than 200 million websites by the end of 2009. This is huge for any CMS on the market, more so for an open source blogging platform. I won’t get into what made WordPress CMS spread so much, as this is not the purpose of this post. I’ll only point out one of the things that contributed to this tremendous spread of WordPress: it’s templating system, the ease of customizing its themes and the great number of free and premium WordPress themes available.

However, despite the huge number of WordPress themes on the market and the “boom” in theme development for WordPress powered websites, one thing I’ve noticed in most of the themes I’ve tested and the new ones that come out: a very non-SEO choice of html tags for the blog and post titles, leading to a decrease of SEO power of the title tags. To understand what I’m talking about, let’s take a look at the HTML coding of the default WordPress theme – that probably served as a model for a lot of the themes available now. Read more

Backup and Restore Large MySQL Database on Windows Platform Fast

I’ve been working on a PHP/MySQL project for the last few months that got to a point where database size matters in both running the queries as well as exporting (backing-up) and importing (restoring) the database. The database is about 800MB and it holds two tables with more than 1 million and half rows and other few tables with more than 500.000 rows each, all of them having indexes on 3 to 8 fields. I’m not gonna talk now about optimizing queries or the database structure to make a large database like this run faster, but rather focus on the second problem this database size and structure poses to a developer (at least on a Windows machine): using MySQL commands, even from the command line, to import a MySQL dump of this database, with millions of rows and large indexes needed to be rebuilt on each row takes hours, literally.

The closest working solution that I’ve come with about a month ago was to create a query that removed the indexes from the large tables, another one that would restore them back and do the import in 3 steps:

  1. run the first sql query to remove indexes on the problematic tables
  2. run the MySQL  import for the whole MySQL dump (only import data, since dropping and creating tables would have put back the indexes before the import – which of course I didn;t want)
  3. run the second query to restore the indexes on the large tables

Using this technique I’ve managed to import the database in about 40 minutes, which is not that bad, compared to the normal MySQLdump import (with indexes in place) that would have taken hours. But still, it felt like there should have been a better solution to this. Read more

SEO better performance through CSS content positioning

As I’ve written in a previous article called Search Engine Optimization through CSS, some very good search engine optimizations can be done on a page by using the power offered by CSS. One of the most important things – and yet very little known about – for improving your page SEO is the position of each peace of content within your page markup. To get a better understanding of this, let’s follow the steps a search engine goes to read a page.

First, the search engine gets the whole markup of the page, as it is. Next step, it strips all the HTML, CSS, JavaScript tags and any other markup, who’s only purpose is to give the content of the page a visual layout, since the search engines don’t “see” and don’t “care” about how a page looks. All they care about is content. Now that the content is “naked”, striped off of anything else, the engine starts analyzing it. Of course no one knows exactly how this analysis goes, but some things involved in the content ranking process are known. Read more

Search Engine Optimization through CSS

Few years ago, when CSS itself was “the new wave” in web design, when most of the web pages used tables within tables within other tables to be able to render a decent layout, well, back than, CSS was mainly a new tool for creating more flexible, better looking web pages. Search engines were also in their early years and SEO (Search Engine Optimization) was only a distant concept for most of the people, with very few things known beyond the title and keywords meta tags. Things changed a lot since then. Today, the search engines and their algorithms evolved so much, and with thousands of websites getting launched everyday the fight for the topmost places in the search engines results means way more than just writing a keyword reach title or filling the keywords meta tag with a bunch of more or less related phrases. Read more

A multi-language WordPress blog with WPMU

Right from the start I wanted to have my blog in two languages: Romanian and English. So I’ve started to look for plugins and other solutions to accomplish that. To my surprise, I couldn’t find a good working solution for having a single blog in two or more languages.

I have tried “xlanguage” and “qtranslate” as multi-language wordpress plugins, but the results were far under my expectations. It seems that neither of these plugins won’t separate completely one language data from another. They allow you to have posts, pages and categories in different languages, but what about the rest of the information in the blog. Read more

The blog number 100.540.327 was, finally, born

Meaning the blog you are reading!

Obviously, I don’t know if the number is correct – mathematically speaking there are 99.9999….. percent chances not to be, but that doesn’t matter anyway, it’s just a way of saying a new blog was born in the endless of the blogosphere.

If it will be read, by whom, when and where… we’ll have to wait and see. One thing I’m sure of: there were so many moments when I wanted to be able to share an idea, a thought, a feeling, a big joy or a great sadness, a web script or a photography… so, in the end, I decided that it was probably the time to get this blog started. Read more