Check out the testing simulation made by 3D artist Clement Morin.
Clement Morin has shown his test result of a new X-Particles FLIP/APIC solver. The simulation with the foam takes 3 minutes.
Water and foam simulation is a quite complicated task to do but the results are always satisfying. If you’re interested in creating river FX in Houdini, read the breakdown by Jasper Macks where he dived into the details of his approach to fluid simulation as well as ways and resources to learn the tool.