I’ve written a new title renderer using GD2/FT2, and it works MUCH better. It didn’t automagically switch fonts to draw the Japanese, but I wrote a (slightly nasty) chunk of code that breaks it up into several rendering operations.
I still can’t decide whether I should cache the results, or just re-render them every time. Am going to look into the CPU usage of the text renders, but it seems very mild (the images render and load as quickly as the cached ones).
| SELECT option_value FROM wp_options WHERE option_name = 'siteurl' | 0.00036191940307617 |
| SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | 0.00064897537231445 |
| SELECT option_value FROM wp_options WHERE option_name = 'widget_text' LIMIT 1 | 0.00020313262939453 |
| SELECT option_value FROM wp_options WHERE option_name = 'widget_rss' LIMIT 1 | 9.7990036010742E-5 |
| SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'new-renderer-test-%c3%b8-%c3%a6-a-e' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC | 0.00022006034851074 |
| SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (14) ORDER BY t.name ASC | 0.00097107887268066 |
| SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (14) ORDER BY post_id, meta_key | 0.00011014938354492 |
| SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'uncategorized' LIMIT 1 | 0.00015783309936523 |
| SELECT * FROM wp_users WHERE ID = 1 LIMIT 1 | 0.00010395050048828 |
| SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1 | 0.00012087821960449 |
| SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2007-01-02 14:28:38' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1 | 0.00017213821411133 |
| SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (11) ORDER BY t.name ASC | 0.00077104568481445 |
| SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2007-01-02 14:28:38' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1 | 0.0001671314239502 |
| SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (15) ORDER BY t.name ASC | 0.00072002410888672 |
