Page 1 of 1

3.7.1 too slow

Posted: Sun Sep 05, 2021 9:08 pm
by euskir
Hello there,
I love Vienna since the very beginning, but lately is almost impossible to use.
I need to reindex database all the time, and is extremely slow to update just sixty feeds.
At the same time is to complicated to open and close, ages to finish those tasks.
Any help will be welcome!!!

Re: 3.7.1 too slow

Posted: Wed Sep 08, 2021 6:51 pm
by throw.away.name
My personal experience has been if it's running slow, you have too many read articles that need to be deleted.
Of course, this assumes you made changes to save more than the default number.

Re: 3.7.1 too slow

Posted: Sat Sep 11, 2021 4:32 pm
by karstenwo
Hi,

I had the same problem. Vienna took up to a minute after clicking on a feed until the messages show up. Today I looked into the database and had some insights:
  • vienna does not delete messages. It sets field "deleted_flag" to 1
  • the fields "deleted_flag" and "read_flag" are not indexed.

Adding these two indexes to the database made Vienna considerably faster and fun to work with again:

Code: Select all

CREATE INDEX messages_read_flag on messages(read_flag);
CREATE INDEX messages_deleted_flag on messages(deleted_flag);
YMMV, of course you made a backup, if you don't know where to find the db or how to apply the change you should not do this.

This is a fix that should be in a new release.