TonyW - guess you either didn't read my post thoroughly or just decided it's not correct, however - A 512x512 PIXEL image will be the same file size no matter what DPI it has set. DPI is meaningless, it's just a multiplier.
I work with print production and often run into people adamantly believing DPI misconceptions - that it has some magical meaning beyond the pixel size of an image. Hence my wish to educate.
Let's ask our friend Photoshop:
Look at the DPI, pixel size and file size (Image Size: 768,0K on top). 512x512 pixels x image bits will ALWAYS be the same - DPI doesn't mean jack.
C2 also only deals in pixels and won't magically downscale or upscale the image. If it's saved as 512x512 pixels it will be the same in C2, no matter the DPI.
If you work in real-life sizes - in print, for example, look at EFFECTIVE DPI of the final image, in pixel graphics DPI is meaningless.