Rene Giretzlehner

We have configured the database via server_config.py `SQLALCHEMY_DATABASE_URI = 'sqlite:////home/deep/knowledge.db'` and startup the server with `knowledge_repo --repo {magic}/home/deep/deepthought --repo {webposts}sqlite:////home/deep/dbrepo.db:mypostreftable runserver --config server_config.py --port 80` So the database grows over...

Thanks for your feedback - I'll give a MySQL a try and let you know if this resolves our issues!

Short update - it got worse ;-) I installed MySQL and start the server now with this command: `sudo knowledge_repo --repo {magic}/home/deep/deepthought deploy --config server_config.py --port 80` `[2017-03-23 17:17:43 +0000]...

I downgraded to 0.7.5 - still the same issue :-) High CPU load on each post pageview. Do you have any other idea what this could cause?

haha...not so many right now - we just started testing / playing around with it - but want to use it for all our knowledge posts from datascience & engineering...

a usual post contains 10-20 images (png) each between 30kb-45kb.

we did a test without images in the post - renders super fast :-) so the root-cause seems to really be the images. is there anything we can do?

I changed to MySQL as you suggested already last week, but it did not improve the behaviour - so no SQlite db in use anymore on our system. `sudo knowledge_repo...

@matthewwardrop we tested the fix - didn't help in our case. anything we could test further?