You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
H2 currently does not automatically DEGRAF / COMPACT the database on quit. This creates huge file sizes.
We need to explore further to see if we can make this run automatically
the command to run compact is
shutdown compact
but I dont think CRON is the solution here since the command shutsdown the db performing compact operation
so the db connection will most probably be disconnected
We shell / bash script to stop the geoweaver server and perform the operation and restart the server would be the best, we can do this at time when we expect no traffic like 3 AM
The text was updated successfully, but these errors were encountered:
This operation should be performed automatically.
A better alternative is by using SQLite which needs testing to make sure it is a drop-in replacement for H2.
H2 currently does not automatically DEGRAF / COMPACT the database on quit. This creates huge file sizes.
We need to explore further to see if we can make this run automatically
the command to run compact is
but I dont think CRON is the solution here since the command shutsdown the db performing compact operation
so the db connection will most probably be disconnected
We shell / bash script to stop the geoweaver server and perform the operation and restart the server would be the best, we can do this at time when we expect no traffic like 3 AM
The text was updated successfully, but these errors were encountered: