There was some investigation into these: SATA2PATA adapters experience
- Most STAT-->PATA bridges these days have Jmicron chips labeled JM330, JM20330, & "IDE/SATA DOF" (a die shrink or clone of the JM20330). They are usually 1 directional bridges. They either go PATA-->SATA or SATA-->PATA but not both. The performance is very good. They all perform about the same (within the testing margin of error).
- The other brand that you can find has chips labeled "SunPlusIT" . They seemed to be about 5-10% slower, and the adapters cost more, but they are usually bi-directional. The same adapter can do PATA-->SATA and SATA-->PATA
- I got one with a Marvell chip (88SA8052). They don't seem to be in active production anymore. It seemed to have roughly same performance as the Jmicron in the testing that I did. I've seen pictures of bi-directional Marvell bridges, but I don't have one
None of these devices did DMA2 (aka WDMA) for me, so they might not be a good fit for late 486 or Pentium systems. Consider an industrial CF or an SD bridge instead. Getting a device to do a particular ATA transfer mode involves interplay between the storage controller, the bios, the storage device, any device drivers loaded after boot, and sometimes the cable. Maybe I just didn't find the right combination. The Marvel chip did run for a couple seconds before crashing when I forced DMA2 mode on a promise 20630 VLB controller, but it still crashed every time.
Matze79 found a fm4-4383 bridge from Canon that has a chip labeled "bu19503kv". He said it worked well on older systems. I don't know much about it
I also hit a curiosity yesterday when connected a Jmicron bridge with a 40 conductor cable to I try to force UDMA2. Turns out my SATA bridge ignored PIN34 and tried to negotiate UDMA5 on both 40 conductor cables that I tried. I don't recommend running UDMA 5 on a 40 conductor cable. It was pretty clear when looking at the jagged speedsys storage performance graph that there were a lot of data transmission stops and restarts. Once cable was no good at all, the other was like 50% speed. Whatever the case, it wasn't healthy. So maybe avoid 40 conductor cables with SATA Bridges.