I want two share some experience that I’ve got some time ago on the Netezza related testing.
This article is not just around Netezza emulator, but the approach described below allowed me to save a lot of time on testing within I/O-greedy configurations (the laptop was just equipped by slow IDE HDD but with 16 GB of RAM).
The problem I’ve faced was very slow performance of test SQL statements execution and I assumed that using of RAM Disk approach hypothetically could help me.
Starting from that point I planned to accomplish the following steps:
- Find and Setup the RAM Disk for Windows software (I’m sure there are kind of alternatives are available for other platforms)
- Setup it
- Place the Netezza VM into the virtual disk and spin it in RAM
- Get the performance profit :)
The progress and the pitfalls:
- I’ve chosen the SoftPerfect RAMDisk as a software and it was really perfect. It’s useful and intuitive from installation and using perspectives.
- I’ve placed the VM image into the newly created RAM folder (8GB).
!Pitfall is there! When I didn't get expected performance boost, I've just installed the VMPlayer into the RAM folder as well as the VM image I've copied into it.
- Started VMPlayer newly installed into RAMDisk
- Started Netezza VM…
Viola! My Netezza VM start working 10 times faster
(on my own hardware of course :)