21 Mar

Blog about your passion and share with others!

One evergreen means of creating and sharing valuable content in the online space – the internet, is through blogging. Think of blogging as having an online diary where you can put your thoughts, ideas and experiences in the form of content on the internet for interested people to gain value from. If you are passionate about any topic, one way of offering value to people like yourself in the same niche is by setting up a blog for this purpose. The good thing about it is that you can be flexible with your blogging without any exhaustive routine.

You can also see blogging as a form of creating a presence for yourself. … Read the rest

12 Feb

NAU Extended Campuses

A great alternative for people who want to save a few dollars on their 4-year degree but still want to gain a quality education from a premier university. The Extended Campuses of Northern Arizona University (NAU) makes a high-quality college education more accessible and affordable for people everywhere through its network of statewide campuses, lower tuition, and innovative online degree and class option. They have in-person classes available in Yuma, Phoenix, Tucson Arizona, and online classes available too. Learn more here.

20 Jan

WordPress Meta Query Slow – WP_Query

I recently had a quite simple meta_query produce really slow response times – 9 seconds to return 2 rows! The meta_query was simple:

[meta_query= array(array(key => 'mykey'
                            [value] => array(3956)
                            [compare] => IN
                        )
)

Resulted in a query such as

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
WHERE 1=1
AND wp_posts.post_type = 'myposttype'
AND ((wp_posts.post_status = 'publish'))
AND ( wp_postmeta.meta_key = 'anotherkey'
AND ( ( mt1.meta_key = 'mykey' AND CAST(mt1.meta_value AS CHAR) IN ('3956')))
)
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 ASC
LIMIT 0, 32

The problem came to light looking at the query plan – the table wp_postmeta was using key meta_key and returning 292058 rows with information:
Using index condition; Using where; Using temporary; Using filesort

Removing that cast changed the query to use the same table, key, and query plan, but to only return 257 rows.… Read the rest

30 Aug

Formula E – Electric Race Cars

I’m looking forward to electric race cars in Formula E though might be weird not hearing the noise of the petrol engines as they whizz past. Interesting they are planning to change cars when the batteries run out, would have thought they could just change batteries which would seem a more logical choice if they want the technology to eventually move to standard vehicles.

Also street circuits are  planned, in Formula 1 street circuits tend to be less exciting due to fewer overtaking opportunities, though this year has been an exception – don’t want Formula E to be dull!

More details in this article from BBC News http://www.bbc.co.uk/news/business-19402383