Performance Improvement #62
Description
Currently, using the POCO interface ReadByteArray() is called on SocketReadOnlyStream for every column and every row of the results of a query. In my case that's 4.2m times for a typical query. This seems to hammer the CPU. Probably because of all the Windows socket API calls?
The only solution I can see is to buffer each frame body into a memory stream. I've forked and stripped your driver right down and just by implementing buffered frames, see ~50% better performance for large queries.
Maybe in cassandra-sharp a BufferingFrameReader could work? Such an implementation could provide an easier way of supporting compressed frames also.