The python driver that we bundle with Cassandra for cqlsh is the normal python driver (https://github.com/datastax/python-driver), although sometimes it's patched for bugfixes or is not an official release.
On Sat, Mar 28, 2015 at 5:36 PM, Ben Bromhead <b...@instaclustr.com> wrote: > cqlsh runs on the internal cassandra python drivers: cassandra-pylib and > cqlshlib. > > I would not recommend using them at all (nothing wrong with them, they are > just not built with external users in mind). > > I have never used python-driver in anger so I can't comment on whether it > is genuinely slower than the internal C* python driver, but this might be a > question for python-driver folk. > > On 28 March 2015 at 00:34, Artur Siekielski <a...@vhex.net> wrote: > >> On 03/28/2015 12:13 AM, Ben Bromhead wrote: >> >>> One other thing to keep in mind / check is that doing these tests >>> locally the cassandra driver will connect using the network stack, >>> whereas postgres supports local connections over a unix domain socket >>> (this is also enabled by default). >>> >>> Unix domain sockets are significantly faster than tcp as you don't have >>> a network stack to traverse. I think any driver using libpq will attempt >>> to use the domain socket when connecting locally. >>> >> >> Good catch. I assured that psycopg2 connects through a TCP socket and the >> numbers increased by about 20%, but it still is an order of magnitude >> faster than Cassandra. >> >> >>> But I'm going to hazard a guess something else is going on with the >>> Cassandra connection as I'm able to get 0.5ms queries locally and that's >>> even with trace turned on. >>> >> >> Using python-driver? >> > > > > -- > > Ben Bromhead > > Instaclustr | www.instaclustr.com | @instaclustr > <http://twitter.com/instaclustr> | (650) 284 9692 > -- Tyler Hobbs DataStax <http://datastax.com/>