3.7.1 too slow

An RSS/Atom newsreader with features comparable to commercial newsreaders.
Post Reply
User avatar
Posts: 77
Joined: Sat Sep 30, 2006 8:54 am
Location: San Isidro, Argentina

3.7.1 too slow

Post 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!!!
Posts: 18
Joined: Mon Oct 29, 2018 4:30 pm

Re: 3.7.1 too slow

Post 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.
Posts: 4
Joined: Fri Oct 09, 2020 9:30 am

Re: 3.7.1 too slow

Post by karstenwo »


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.
Vienna Team
Posts: 661
Joined: Sat Nov 12, 2011 11:10 am

Re: 3.7.1 too slow

Post by barijaona »

Thanks for this ! This improvement will soon be introduced into Vienna.
I contribute to Vienna RSS as a developer.
Please, don't forget those tips for writing a good bug report
Post Reply