timbuktutraveler wrote:
I have the SONY RX100 VII with it 24-200 lens.
A fantastic small camera that I have taken all over the world.
Actually you don't.
You have a camera with a 9mm to 72mm zoom lens.... these are the lens' actual focal lengths.
It is the RX100's little 1" sensor (smaller than DX/APS-C) that makes that lens "act like" a 24-200mm would on a full frame camera.
Full frame = 1.0X
DX APS-C = 1.5X
Micro 4/3 = 2.0X
Sony 1" = 2.72X
Because of all the different sensor sizes used in non-interchangeable lens digital cameras, it is common practice to state their lens focal lengths in full frame (or 35mm film) "equivalents". This is done to allow comparison of the cameras.
Those small sensors have come a long way and are able to produce overall very good image quality.
HOWEVER the combination of sensor and lens' actual focal lengths strongly effect depth of field, limiting how much background blur effect can be achieved. In fact, APS-C format is roughly 1 aperture stop less than full frame, Micro 4/3 about 2 stops, and 1" close to 3 stops. In other words, if you want the effect of f/2.8 on full frame (say for a portrait), you will need f/2 on APS-C, f/1.4 on a Micro 4/3 format camera... and f/1.0 on a 1" sensor! The opposite is true, too. If you want great depth of field (such as for landscape photography) you might choose a small aperture like f/16 on full frame, will only need f/11 on APS-C, f/8 on M4/3 and f/5.6 on a 1" sensor. So like many things in photography, this is both a positive and a negative consideration, depending upon what is being done with the camera.
PLUS, due to the smaller sensor there will be a limitation on the camera's highest usable ISO. This is a subjective topic... depends upon the user, what they shoot, how they use their images and how much noise they will tolerate in an image. DXO and others rate sensor noise to come up with an optimal ISO figure, for sake of comparison.
The 21MP DX Nikon D500 DSLR (now 9 years old) is rated ISO 1324.
The much newer 46MP FX Z7 Mk II is has a low light rating of ISO 2841.
With it's lower resolution 24MP FX sensor, the Z7 Mk II is rated ISO 3690.
20MP Sony RX100 VII with it's much smaller sensor is low light rated to only ISO 418.
In other words, the original poster's DX format D500 produces usable images about 1.5 stops higher ISO than the Sony RX100 VII.
The newer full frame mirrorless do even better...
Z7II has more than 1 stop higher usable ISO than the D500, more than 2.5 stops higher than the RX100.
Z6II is even better, with 1.5 stops more usable ISO than D500, close to 3 stops higher than RX100.
The Sony RX100 VII certainly is a great camera... for what it is. But, like all cameras, it has pluses and minuses, handy features and capabilities, as well as some limitations and compromises. While it may be a perfect camera for some people, it might be entirely the wrong choice for others.