A RAM drive is not a good idea. The OS does filesystem buffer caching in RAM, that's more or less a RAM disk for the data you use frequently.
You're on the right track though. With the CPU usage you posted you are clearly IO bound.
What will help? Assuming you can't do anything to optimize the code or simplify the dataset:
1) More system RAM. With enough buffer cache you will no longer be IO bound. Also helps to shut down programs that use a lot of RAM.
2) If that doesn't help enough, faster IO. A RAID0 with a few 10k drives would probably help.
Martin
You're on the right track though. With the CPU usage you posted you are clearly IO bound.
What will help? Assuming you can't do anything to optimize the code or simplify the dataset:
1) More system RAM. With enough buffer cache you will no longer be IO bound. Also helps to shut down programs that use a lot of RAM.
2) If that doesn't help enough, faster IO. A RAID0 with a few 10k drives would probably help.
Martin