The Ultimate List of WordPress Statistics


WordPress usage and popularity

  •  WORDPRESS RUNS 4.5% OF THE ENTIRE INTERNET. [12]
  • 50-60% is WordPress’ share of the global CMS market – making it the most popular CMS of them all. [8][2][15]
  • New York Observer, New York Post, TED, Thought Catalog, Williams, USA Today, CNN, Fortune.com, TIME.com, National Post, Spotify, TechCrunch, CBS Local, NBC all use WordPress. [32]
  • 17 posts are published every second on WordPress sites around the world. [4]
  • 37 million global Google searches for “WordPress” are made per month. [4]
 Around 15,886,000 websites on the entire web use WordPress. [15]
  • 8% of the top 100 blogs according to Technorati are managed with WordPress. [7]
  • 2,645 of the top 10k websites on the web use WordPress. [15]
  • 22,111 of the top 100k websites use WordPress. [15]
  • 297,629 of the top 1M websites use WordPress. [15]

In 2014, non-English WordPress downloads surpassed English downloads for the first time. [8]22% of new domains in the US are run with WordPress. [6]WordPress as a CMS (47%) is nearly 12 times more popular than Drupal (4%) in India.

Continue reading

Advertisements

12 Oracle Design Consideration


Effective Schema Design

  • The Schema Plays an important role in  tuning joins
  • Choose data types for all primary and unique keys carefully, and remain consistent through out the schema
  • If you primary key column is varchar2(100), such a primary key is expensive because the large key must be carried in every referencing table, and also because Oracle bust compare long strings when performing a join
  • Create Index where necessary and if possible try to create indexes on multiple columns
  • Normalize your tables , so that there is not a lot of redundancy
  • Put necessary constraints on the table so that you have the right data.

Continue reading

11 House Keeping in Oracle


Invalid Optimizer Statistics

  • Statistics are used by the optimizer to come up with a good execution plan
  • Sometimes optimizer statistics might be  stale or missing

The statistics may not always be accurate because the size of the table might have changed from a few 100k rows to a few million rows. There fore statistics should be periodically collected  and be made as part of the database maintenance routines.

Continue reading

10 Oracle Hints to the Database


Hints

A hint is an instruction passed to the optimizer through comments in an SQL statement. Hints enable you to make decisions normally made automatically by the optimizer.

Continue reading

08 Considerations while using PLSQL in programming (Oracle)


Reduce the number of trips to the Database

Every time SQL is executed, Oracle needs to perform all the internal processing steps, so try to reduce the number of database accesses. This reduces a lot of burden on the database.

Example: If you want to fetch the data of 2 products in the PL/SQL programming language.

Continue reading