database

Improve WordPress Comments Load time when using Akismet: Adding an index to wp_comments

by

A customer of mine was seeing a 15 second load time on their WordPress site when clicking on “Comments”. I installed Query Monitor and saw that the Akismet plugin was running the following SQL command on each comment. SELECT COUNT(*) FROM wp_comments WHERE user_id = 1820 AND comment_approved = 1; This query was to show how many comments the user had previously … Read more

Looking at Cassandra (DB) and Hiphop (Compiling PHP to Native C)

by

I was all over the internet one day and ran into a project called Cassandra. Which was opensourced by Facebook and is being developed by Apache committers as well as other major companies. http://cassandra.apache.org/ I also dug up another Facebook related project called Hiphop, which compiles PHP into native C to boost performance. Also used … Read more