jaapv
RFF Sponsoring Member.
That is a quite surprising insight. To begin with, it disregards the main factor in this equation, being focal length. A resolution limit imposed by DOF ( which is a highly debatable quantity anyway) does not exist at all. DOF does not exist in the focal plane, where resolution is seen.
I've heard that ~10 megapixels is the upper limit for handheld photography. Any higher, and motion blur (even at 1/250) and depth of field (even at f/16) limits the detail you'll see in the image.