Yeah, I was thinking that I probably don't need to stripe two SCA drives in the StudioArray,
This depends on a lot of things! How old are those SCA disks? If they're SCA disks from the olden days when SCA was used in things like the original SGI Octane and the O2, they may actually benefit from being run in tandem. The first generation of SCA wasn't *that* fast.
However, if you're talking about U160 or newer disks that use the SCA connector, then essentially nothing Apple or any Mac clone that's beige can gain anything from running them in RAID from the onboard controller. If you have a good PCI controller, then it may be worth your time.
For what it's worth, in fact, I would be completely unsurprised that a fast 10/15k 2.5-inch U160 or U320 is faster than NuBus itself. But we're talking about a disparity of ten to fifteen years between "system" and "disks."
If I ever run into some extra money, I think I'll just bite the bullet and get a SATA card and a relatively cheap SSD for my G4.
This is probably what I'd do if I had a Power Macintosh G4 on hand. Even a fresh 5400/5900 or 7200rpm spinning disk will be a large improvement over anything IDE, and if your scsi disks are dying, it may be faster than they are, too.
those 15k's generate some heat.
And of all the Macs ever, I'd argue that most Power Mac G4s are better at having some air to begin with, and pushing it through the enclosure. This is especially true in comparison to some of the more compact 68k Macs, such as the IIci.
If you wanted to be safe and have a number of fast old hot SCSI disks, you may look into something like one of the old Sun STOR-EDGE shelves or something like the Sun 711 disk pack, which had reasonably good cooling for what it presumed at the time was up to twelve half or full-height disks. You may even consider mounting them in an old AT PC case, or grabbing something like
this if adequate cooling for a lot of SCSI disks is a priority.
One Mac I'd be interested in seeing the exact thermal performance of, or maybe just having one or two of so I could test this theory out, is the Quadra 950/AWGS95. The AWGS9150 would also be fun, and the combination of the 9150, system 8.1, and ASIP5 or ASIP6 could make a particularly good old server, especially given that the 9150 and 950 seem like they have a reasonable amount of air and a reasonable path for air to flow over the disks and out the back of the machine. Although I haven't looked in particular.
As a sidenote, one entertaining thing I've long wanted to do is grab an old disk shelf from a server (Something like any older Dell PowerVault enclosure, the 630f would be a good example) and rip most of its guts out, leaving just the structure for disk mounting, power and some fans, and adapting it to the task of holding modern disks.
Good luck on your SCSI adventures!