I was shocked, since I'm quite convinced of the serendipity system. I figured, it could be a plugin issue, since the query in question seems to be in connection with the multilanguage-plugin.
Code: Select all
# Time: 111118 15:38:36 # User@Host: xyz # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 3034062 use db_xxx; SELECT multilingual_body.value AS multilingual_body, multilingual_extended.value AS multilingual_extended, multilingual_title.value AS multilingual_title, e.id, e.title, e.timestamp, e.comments, e.exflag, e.authorid, e.trackbacks, e.isdraft, e.allow_comments, e.last_modified, a.realname AS author, a.username AS loginname, a.email FROM multikuli_entries AS e LEFT JOIN multikuli_authors a ON e.authorid = a.authorid LEFT JOIN multikuli_entrycat ec ON e.id = ec.entryid LEFT JOIN multikuli_category c ON ec.categoryid = c.categoryid LEFT OUTER JOIN multikuli_entryproperties multilingual_body ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_en') LEFT OUTER JOIN multikuli_entryproperties multilingual_extended ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_en') LEFT OUTER JOIN multikuli_entryproperties multilingual_title ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_en') WHERE isdraft = 'false' AND e.timestamp <= 1321627200 GROUP BY e.id ORDER BY last_modified DESC LIMIT 1;
Actually I only have very few articles (about 10 out of 300), which needed translation. Is there a way to use the multilingual plugin (and execute the joined query) only when needed? Should I use static pages for those few english pages instead of employing the multilingual plugin?
What else coul I do to optimize my blogs performance and to content the provider (besides using the cache plugin which I just learned about while searching the forum)?
The blog link is: http://www.multikulinarisch.es
I took some time to further explore the entries with property 'multilingual_body_en' in table_entryproperties.
I got a list of 36 such entries in the database. That as wird,since there were onl 3 english articles. I found out, that the auto_save plugin saved lots of entries with the property 'multilingual_body_en'.
I deactivated auto_save plugin and deleted the [autosaved] entries. I guess that still doesn't solve the speed problem, though...
Thanks for your time!