Honestly, if you care about that level of concurrency, it begs the question of why are you using an in process database in the first place?
One reason is that architecture and maintenance are much simpler
One reason is that architecture and maintenance are much simpler