Page 1 of 1

SQLite support

Posted: 31 Mar 2013, 21:05
by harshdeep
Hi Team,

TTRSS is really handy tool, but on Raspbarry Pi it is running very slow because MySQL running on SD card is becoming bottlenack. I am sure it has been in to-do list bust just wanted to toss an idea of SQLite as back-end, as it might improve performance on Raspbarry Pi (and/or low end machines)

Thanks,
Harshdeep Mehta

Re: SQLite support

Posted: 31 Mar 2013, 23:39
by fox
tt-rss actually uses database functionality beyond glorified grepping with sql syntax, so I'm afraid this ain't happening any time soon.

Re: SQLite support

Posted: 31 Mar 2013, 23:57
by cy8aer
Some years ago I changed from MySQL to Postgres. After this tt-rss went smoother. That was on a 500MHz VIA Epia box, so nearly the performance of a raspi. Maybe this will help...

Re: SQLite support

Posted: 01 Apr 2013, 03:36
by joseph-mx
cy8aer wrote:Some years ago I changed from MySQL to Postgres. After this tt-rss went smoother. That was on a 500MHz VIA Epia box, so nearly the performance of a raspi. Maybe this will help...


hmm..Postgres perform better than mysql?
i am not sure..

:shock: :shock:

i am still a fan of mysql. Perhap, you can look into optimize the mysql settings.. add in caching.. might help improve performance.

Re: SQLite support

Posted: 01 Apr 2013, 08:33
by fox
>i am still a fan of mysql.

There's your problem right there. :)

Re: SQLite support

Posted: 01 Apr 2013, 22:39
by lordofthemoon
I just set up TT-RSS on an RPi today and I was finding MySQL to be awfully slow as well. I nuked my installation and configured MySQL to use the MyISAM engine rather than InnoDB. This has sped up performance no end, although at some costs.

Re: SQLite support

Posted: 01 Apr 2013, 22:46
by fox
>although at some costs.

You are about to have some major fun without foreign keys or transactions or delete cascade or anything really.

Edit: I actually went ahead and tried it, it was pretty hilarious.

Re: SQLite support

Posted: 01 Apr 2013, 23:13
by lordofthemoon
You are about to have some major fun without foreign keys or transactions or delete cascade or anything really.

Yeah, I know about the limitations, but it was just about unusable on the RPi with InnoDB. I'll not be doing any major development or anything on it, just using it to run TT-RSS :).

Re: SQLite support

Posted: 01 Apr 2013, 23:15
by fox
Create a category, put a feed into it, delete category. Minor hilarity ensues.

Re: SQLite support

Posted: 23 Dec 2013, 00:59
by gerhardy2408
Hi,

I'm also using a Raspberry Pi, and have a few DBs running with mySQL (WordPress, roundcube, owncloud, piwik), and all are running wonderful with the MyISAM engine. And as the RPi has only 512MByte of RAM I want to get rid of the InnoDB engine for mySQL, as it is claimed that a lot of memory is used by it. The mySQL process grabs 20% of my memory! And I still need to run Apache, ...
And the lovely tt-rss is the only DB for that I still need the InnoDB engine.
How can I get rid of that? Which tables I have to alter and what are the drawbacks using MyISAM?
Another option would be to install another Pi just for running the mysql server :-(
Any other ideas are welcome!

Thanks!

Gerhard

Re: SQLite support

Posted: 23 Dec 2013, 01:42
by fox
I have an idea: what if you read a bit before posting further.