@gwil

I'm trying to follow you advice

CSS Stuff is slowly becoming a bit less unpredictable.

After trying oxygraph, allegrograph and apache jena fuseki yesterday I switched to blazegraph, this seems to be the fasted option so far. Being able to easily switch database and potentially enjoy performance benefits is a main advantage of the #tricerascuttler approach compared to domain specific databases like #ssb-db2.

The page showing the latest posts still takes much longer than the acceptable 400ms. I guess that sorting 400'000 messages in order to take the most recent ones just takes some time.

By contrast, showing the following relations seems surprisingly fast, even though the query to derive them from the messages is quite complex. What could make this even faster is to generate a derived graph with the following relations, so that querying for friends-of-friends would no longer require going through thousands of messages to get the current follow/unfollow status.

The instance at http://ssb.farewellutopia.com:8000/about.html is still there and you're welcome to test it online if you don't yet feel like checking out the repo and starting your own instance with #docker-compose.