Greetings,
run following commands in Mysql Query browser or from Mysql console.
CREATE INDEX IDX_Articles_feed_id ON articles(feed_id)
and after that run
optimize table articles
Following index is normally automaticly created, next FR(MYSQL) release fixes this issue.
Ingmar
------
FR dev
I guess that doesn't affect the database cleanup speed too much. That's still slow has hell with 150k of articles in database.
I have optimized "delete" sql code, currently we are working on nasty odbc bug, it's little bit a way of showstopper for next release...
But I'll notify if new release is done.
Ingmar
------
FR dev
nice one! CPU usage seems
nice one! CPU usage seems better.