[quote="@DonaldB"]not even disscussing this any more GB as no one here has any experience shooting macro, its just wasting my time.
Light is a wave, not a particle. However, when light energy is measured, the measurements give discrete amounts, which we call photons, and can be interpreted as a particle. The likelihood of measuring that energy has quite a bit to do with the wavelength of that light (where that wavelength is a function of the "color" of the light, with "red" having about twice the wavelength as "blue", and "green" splitting the middle). In the case that the wavelength is larger than a pixel, then it becomes more likely for adjacent pixels to record the light rather than the pixel located nearest the wavelength peak, thus resulting in diffraction blurring. This is where we get the Airy Disk from, by the way.
In any case, no one here has said, or implied, that diffraction does not reduce resolution. In fact, we all acknowledge it without hesitation. What we are saying is that having more pixels will still increase resolution, albeit with less and less increase as the diffraction increases and/or pixel size shrinks (you may have heard one or more of us use the term "diminishing returns"). However, in no case does more smaller pixels result in less resolution than fewer larger pixels. So, if the photos show greater resolution from the sensor with fewer larger pixels, the cause is something other than pixel size, and it is this point -- determining what the other cause(s) may be -- that we are arguing about, whereas you are wrongly fixated on pixel size being the culprit.
If you can explain how a "normal" lens differs from a macro lens with regards to resolution, diffraction, and pixel size, please spell it out!
Imagine if Neil Armstrong would only listen to other people who had set foot on the Moon. 😟