I use SuperSpray particles for my fountain's animation. It is enough to create any musical fountain.
However, 3ds max have a little problem... Viewport really lagging when you move a slider time. Especially if you need to move a few frames back.
My computer is really old. So I had to learn to deal with it.
The first thing to do is cut the animation by the part of 10-30 seconds. Not more. It will speed up rendering. In addition, it breaks a large task into subtasks. This is a good project management. I usually use no more 5 parts for my animations.
Second one - hide layers with unused SuperSprays. Usually you use no more 20-50% of particles on the screen at the same time. So you can hide unused.
Third thing. You have several identical nozzles for example. And its can turn on and turn off at the same time only. So you do not need view all of them. You can hide all except one of them. I use "viewPercent". Look at the screenshot.
Fourth. Use the TimeNavigator utility which remembers the current position in the timeline and can restore it. This eliminates the need to manually move the time slider.
Fifth. You need to set the birth of particles is equal to zero if nozzle is unused. It is only way to save computer resources.
Birth=1, Speed=0 - resources still used!!! Remember it.
Sixth. Another one thing - you can cut the particles life. I always use this. For example, you have already completed the first 10 seconds of animation. So you can exclude it from the calculation.
Select all SuperSpray particles. Type start frame. Type end frame. Click "reset".
Do not put too far the distance between the end and the start frame.
Unfortunately, I can not to fix the problem at all. It will lagging from time to time.
I do fountain animations with hundreds of SuperSprays. And I do not upgrade my PC since 2006.
So use this methods in your work! And you can make any fountain you like.
PS Sorry for my English. It is not so perfect :)