windsorsolutions / opennode2-dotnet Goto Github PK

After operating an instance for a couple of years the OpenNode database has become quite heafty and slow. 84 million rows in NActivityDetails table for instance and an overall database size of 67gb. I am running on MSSQL and I was wondering if there is some guidance on what tables are safe to truncate and / or if there are indexes that could be used to speed things up. Thanks in advance!

Is it possible to get this application working with the Ngpsql database provider? We are building an application that OpenNode2 interacts with, but that application's database is in Postgres. It doesn't look like Postgres is supported out of the box, but given that Ngpsql is a ADO.NET database provider, I don't see why I couldn't get this to work. I just wanted to reach out in case there are any limitations that I'm not seeing. Thanks in advance!