dynamicweb / DynamicWeb

Make feature requests for Dynamicweb in Issues section of this repository
https://doc.dynamicweb.dev/documentation/fundamentals/support/feature-requests.html
GNU General Public License v3.0
1 stars 0 forks source link

Have some tables in a different database #171

Open nunoaguiar opened 1 month ago

nunoaguiar commented 1 month ago

Is your feature request related to a problem? Please describe. Databases tend to grow as times goes by, and in on-prem or our own Cloud environments this can become harder to manage. Also taking backups to restore and do local development and/or debug things for Prod sites, we end up carrying unnecessary data around. That increases the time we need and cost (in some Cloud hosted scenarios)

Describe the solution you'd like We would love to have data such as Logs (i.e. GeneralLog), Tracking (i.e. TrackingSession), DebugingInfo (i.e. EcomOrderDebuggingInfo) and Audit tables to a different database, which could be optimized in a number of ways. The same thing would be applicable to the Log files that go with it, which would also prevent a disk writes, thus reducing the usage/need for Premium resources.

Describe alternatives you've considered We're tried to set up automatic cleanup of logs built into Dynamicweb. Nonetheless, with a limited number of days (i.e. 14) it's easy to accumulate multiple GB of log data, which then paired with daily backups end up taking a lot of space

Additional context This topic was discussed with Jeppe at the Summit