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

16 May

Fun with Google Translate

Go to Google Translate;

Copy this text:

pv zk bschk pv zk pv bschk zk pv zk bschk pv zk pv bschk zk bschk pv bschk bschk pv kkkkkkkkkk bschk bschk bschk pv zk bschk pv zk pv bschk zk pv zk bschk pv zk pv bschk zk bschk pv bschk bschk pv kkkkkkkkkk bschk bschk bschk pv zk bschk pv zk pv bschk zk pv zk bschk pv zk pv bschk zk bschk pv bschk bschk pv kkkkkkkkkk bschk bschk bschk pv zk bschk pv zk pv bschk zk pv zk bschk pv zk pv bschk zk bschk pv bschk bschk pv kkkkkkkkkk bschk bschk bschk pv zk bschk pv zk pv bschk zk pv zk bschk pv zk pv bschk zk bschk pv bschk bschk pv kkkkkkkkkk bschk bschk bschk

Pick German as the “from” language; Press the “Listen” button.… Read the rest