slow website

by themba, Monday, February 11, 2019, 23:14 (1891 days ago)

I've been running selfoss for a while now. It was rather sluggish and I always assumed because I was a bit lazy during setup and went with sqlite for storage. I recently migrated to mariadb but was surprised to find no noticeable speedup. In particular the ajax requests takes a long time to load the actual items: ?offset=0&itemsPerPage=50&search=&type=newest&tag=&source=&sourcesNav=false&extraIds%5B%5D=220893&ajax=true

I made some sql queries in the database and although I don't know the exact queries made by selfoss getting the news items that would normally be shown on a page with a similar query is nice and fast (I'm only using this myself for some 100 rss feeds so we're not talking about huge databases anyways).

I tried to dabble into the xdebug profiler but to be honest I'm not really experienced with reading the output of that. It seems however that the ajax request spends most of it's time doing a curl request.

Does selfoss attempt to quickly update my sources when I load the page?
That's not the behaviour I would expect. Is there a config option to change that?

Any further insight much appreciated,
Themba