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
[added]
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!