Feedreader.com - Some hints to add performance - Comments

I have optimized "delete"

ingmar — Wed, 13 Feb 2008 10:04:08 +0200

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

I guess that doesn't affect

premois — Wed, 13 Feb 2008 06:46:40 +0200

I guess that doesn't affect the database cleanup speed too much. That's still slow has hell with 150k of articles in database.

nice one! CPU usage seems

feedjunkie — Wed, 13 Feb 2008 00:18:22 +0200

nice one! CPU usage seems better.

Some hints to add performance

ingmar — Sat, 09 Feb 2008 22:09:17 +0200

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