So my application has the concept of a Server with many clients that all sync with one another regardless of connectivity, but at some point all of the clients will reach back up to the client.
My problem is that the knowledge continuously grows over time and unlike the tracking data.
I would like to find a programatic solution to this and do something similar, such as to delete knowledge that was created 30+ days ago or something along those lines. We are running in to performance issues as the application is currently in development
and is prone to errors at the moment, we noticed that the knowledge can grow uncontrollably and cause can massive performance hits without a full re-provision of database.
Also, we do not want to re-provision and wipe out all the knowledge all at once, as there is binary data floating around and passing that with select changes is not ideal.