Just a quick post to let you know some interesting finding on the sql splitter script i wrote:
The gzip compressed size
The decompressed size
Time taken in seconds
1 2 3
The limiting factors looks to be the cpu with the gzip to gzip as php only runs on one core. Where as uncompressed to uncompressed was IO wait. I need to find if there is a way to run the gzopen used for reading and the gzopen used for writing on different cores.