I use two piece coloplast click system. Seriously the best I have ever used (and I've tried pretty much all the major brands). Usually I would get 3 days out of an appliance with water/sweat condition. I biked the Cuba Island a few years ago and I would generally get 4-5 days out of my flanges (convatec at the time). I did have to deal with quite a few messes during these 2 months though... Since I use coloplast, I never have issues.
I say 8 days but I have two say it was 6 days of "normal" life style and 2 days of beach time (let say 3 hours of wet time a day). It did not break, I just changed it because well, I realized the day we were and that I had "forgot" to change it. I have to say I think the one-piece swimsuit really helped though. I normally was wearing two-piece and well, there would be more "movement" and it would affect the appliance a bit more than the one-piece that snugged everything right in place. By the way, for the ladies, I really found the perfect ostomate bathing suit. I'll try getting a picture on. It's really the closest to a normal bikini I could ever get. Being ostomate for 13 years, I could not be more happy to find that thing, I swear, it's perfect with the clothing effect that hide anything suspicious. Any designer around, we need a real ostomate bathing suit collection!