Are we to understand that since URLs in the database will not be changed, there will be protocol rewrites in every page load, potentially impacting performance… vs a case where all HTTP are rewrote to HTTPS using a search-replace opération?

And once HTTPS is activated, will Site Health consider the site « secure », even though in reality, there remains mixed content in the database?