Hello! Thanks for the great project.
Via other threads here I've become aware of the Windows7Grbits.EnableCreateDbBackgroundMaintenance
My (hopefully quick) questions:
- Our app uses a lot of sessions; is there any issue with setting the attach flag in all sessions, or should it be set on one, long-lived "background" session only?
- Should both flags be set at the same time, e.g. on create then on
attach immediately after, or is the attach flag sufficient on its own?
- Will online compaction reliably improve the performance of subsequent offline compactions? (We just hit a 350 GB fragmented file that would take 40 days to compact :))
Thanks in advance for your advice,