Enrico Weigelt wrote:
Hi folks,Any hints for futher optimization appreciated :) thx
It doesn't look like you have any indexes - I'd add one to at least articles.title and blacklist.title to start with and probably also user_results.article_id and articles.inode_id.
-- Paul Lambert Database Administrator AutoLedgers ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
