As things stand, the TCP_NODELAY flag is not set when the socket is created. For small queries, this is not an issue. However, if doing a large number of queries this significantly slows down the process. As a quick benchmark, without the flag set doing 500 inserts on my database took 125 seconds (250ms/insert). Setting the flag got the total execution time down to about 30 seconds (60ms/insert) - four times faster.
As things stand, the TCP_NODELAY flag is not set when the socket is created. For small queries, this is not an issue. However, if doing a large number of queries this significantly slows down the process. As a quick benchmark, without the flag set doing 500 inserts on my database took 125 seconds (250ms/insert). Setting the flag got the total execution time down to about 30 seconds (60ms/insert) - four times faster.