Not sure about length, but as far as weight I found a P229 to be supremely comfortable in a shoulder holster.
Except for guys with back problems, most of us that do have a shoulder rig typically only wear them when seated in a vehicle for an entire day (like when assigned as a driver), so my experience is limited in that regard.