Here's what theory has to say about optimizing macros - it is simple but took me a long time to realize as the detailed theory is seldom tied together.
When a lens is used for macro photography, DOF depends
only on magnification, m, and effective f-number Neff.
DoF=2CNeff/m^2
For a particular Neff both exposure and diffraction disk size (resolution) are the same.
If you use two different perfect lenses at the same macro magnification and adjust f-number for the same exposure time (constant lighting & iso), DoF & resolution will be the same.
In practice it implies for each lens one should find the highest f-number setting you can use for your magnification before diffraction becomes a problem & use that f-number for all your macros - this will give you the best combination of resolution and DoF.
========== math details follow===============
This is true because Neff takes the actual optical distance from lens to image plane into account. For a lens with pupil magnification ratio, p, (exit pupil)/(entrance pupil),
Neff = N(1+m/p)
Diffraction spot diameter = 2.44 x Neff x wavelength
Last edited by newarts; 10-14-2011 at 11:46 PM.