P&S cameras as fancy as they can be have their limitations. In this case you don't have much choice of closing the lens down for maximum sharpness besides what the camera allows you to do. And you can only get so close to the subject to get more areas in focus.

The flower was close to the ground so a tripod wasn't needed.