Just a quick post to let you know some interesting finding on the sql splitter script i wrote:
The gzip compressed size
1
|
|
The decompressed size
1
|
|
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.