Hi,
Thank you for your feedback about non-working sort by posts count under tags – we will fix it in the nearest release.
Regarding the overall performance – to be honest – Publii was designed for smaller websites and we did not focus on such cases when user has few thousands of posts. Also due nature of the posts listing – it is not easy to implement some pagination etc. without big rewrite of the app views :/