I’m just moving a discussion of #6312. Basically #6898 removed CCoinView queries in CNB for performance reason. But #6312 need more information to check LockTime validty which require CCoinView queries, nullifying performance improvement of .#6898 .
This issue is for brainstorming solutions without polluting #6312 .