I have developed some code to not store the tag translation into the wp_options table option_name qtranslate_term_name field.
It can be improved or stored into the term_meta table, but for my need and with the time I had, I did that.
Basically, it turns 35Mo of serialized array into a 48ko table content.
Posted on http://wordpress.org/support/topic/evid ... st-4054457
You can remove the unique Key, I did it because I need one language.
- Code: Select all
`CREATE TABLE IF NOT EXISTS `wp_qtranslate_terms_lang` (
`term_id` int(11) NOT NULL,
`term_meta` varchar(32) NOT NULL,
`term_value` varchar(150) NOT NULL,
UNIQUE KEY `term_id` (`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;`
Please get the files I updated in the attachement. Some hardcoding but it can serve as a basis to improve the rest.