node.js - Why datastax/nodejs-driver is slow? -


it takes 20 seconds response simple select query using nodejs driver. cqlsh takes less 1 second.

enabled logging on connection , shows lot of connection events below

select * developer username=?  2015-06-13t05:48:39.635z log event: info -- "controlconnection" 2015-06-13t05:48:39.635z log event: info -- "controlconnection" 2015-06-13t05:48:39.637z log event: info -- "connection" 2015-06-13t05:48:44.641z log event: warning -- "connection" 2015-06-13t05:48:44.641z log event: info -- "connection" 2015-06-13t05:48:49.646z log event: warning -- "connection" 2015-06-13t05:48:49.647z log event: info -- "connection" 2015-06-13t05:48:49.647z log event: verbose -- "connection" 2015-06-13t05:48:49.648z log event: verbose -- "connection" 2015-06-13t05:48:49.648z log event: verbose -- "connection" 2015-06-13t05:48:49.651z log event: verbose -- "connection" 2015-06-13t05:48:49.651z log event: info -- "connection" 2015-06-13t05:48:49.652z log event: verbose -- "connection" 2015-06-13t05:48:49.652z log event: verbose -- "connection" 2015-06-13t05:48:49.652z log event: verbose -- "connection" 2015-06-13t05:48:49.653z log event: verbose -- "connection" 2015-06-13t05:48:49.654z log event: verbose -- "connection" 2015-06-13t05:48:49.654z log event: verbose -- "connection" 2015-06-13t05:48:49.654z log event: info -- "controlconnection" 2015-06-13t05:48:49.654z log event: info -- "controlconnection" 2015-06-13t05:48:49.654z log event: verbose -- "connection" 2015-06-13t05:48:49.655z log event: verbose -- "connection" 2015-06-13t05:48:49.662z log event: verbose -- "connection" 2015-06-13t05:48:49.662z log event: info -- "controlconnection" 2015-06-13t05:48:49.662z log event: verbose -- "connection" 2015-06-13t05:48:49.663z log event: verbose -- "connection" 2015-06-13t05:48:49.663z log event: verbose -- "connection" 2015-06-13t05:48:49.684z log event: verbose -- "connection" 2015-06-13t05:48:49.684z log event: info -- "controlconnection" 2015-06-13t05:48:49.684z log event: info -- "controlconnection" 2015-06-13t05:48:49.684z log event: verbose -- "connection" 2015-06-13t05:48:49.684z log event: verbose -- "connection" 2015-06-13t05:48:49.684z log event: verbose -- "connection" 2015-06-13t05:48:49.690z log event: verbose -- "connection" 2015-06-13t05:48:49.718z log event: verbose -- "connection" 2015-06-13t05:48:49.718z log event: verbose -- "connection" 2015-06-13t05:48:49.719z log event: verbose -- "connection" 2015-06-13t05:48:49.725z log event: verbose -- "connection" 2015-06-13t05:48:49.725z log event: info -- "controlconnection" 2015-06-13t05:48:49.725z log event: verbose -- "connection" 2015-06-13t05:48:49.726z log event: verbose -- "connection" 2015-06-13t05:48:49.726z log event: verbose -- "connection" 2015-06-13t05:48:49.726z log event: verbose -- "connection" 2015-06-13t05:48:49.727z log event: verbose -- "connection" 2015-06-13t05:48:49.727z log event: info -- "connection" 2015-06-13t05:48:54.728z log event: warning -- "connection" 2015-06-13t05:48:54.729z log event: info -- "connection" 2015-06-13t05:48:59.734z log event: warning -- "connection" 2015-06-13t05:48:59.735z log event: verbose -- "connection" 2015-06-13t05:48:59.735z log event: verbose -- "connection" 2015-06-13t05:49:00.160z log event: verbose -- "connection"  result 1

any idea why happens?

the node.js driver features node auto discovery. indicates driver become aware of other nodes participating in cluster though single contact point supplied.

looking @ log message in original post see warning messages labeled connection. while don't have full log messages here, guess attempted try 2 unavailable nodes before moving on third node accessible. looking @ source code of driver in connection.js see warning emitted when there error connecting.

furthermore in client-options.js see there timeout on connections of 5 seconds. matches timing between log messages in output.

if driver attempting connect each node failing, waiting timeouts account ~20 second query time. make sure nodes individually accessible , see performance increase.


-

Comments

Post a Comment

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

in android application have 4 buttons facebook , viber , telegram , whatsapp , want share different content based on each button. for example if user clicks on viber button want user action_send share content viber only. i found this explains how facebook , twitter seems it's calling specific class name of application don't know applications wanna use except facebook. all android apps have unique id, first have check if these apps installed in user's device , can pass unique id via intent sharing. according below: unique ids different apps : viber : com.viber.voip telegram : org.telegram.messenger whatsapp : com.whatsapp check if these apps installed , if installed send messages through intent. private void sendmessage(context context,string message, string appids) { final boolean isappinstalled =isappavailable(context, appids); if (isappinstalled) { intent myintent = new intent(intent.action_send); myintent.settype("text/p...
Read more

python - Creating a new virtualenv gives a permissions error -

i'm getting following output when running virtualenv newvenv . traceback (most recent call last): file "/usr/local/bin/virtualenv", line 5, in <module> pkg_resources import load_entry_point file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2727, in <module> add_activation_listener(lambda dist: dist.activate()) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 700, in subscribe callback(dist) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2727, in <lambda> add_activation_listener(lambda dist: dist.activate()) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2227, in activate self.insert_on(path) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2334, in insert_on self.check_version_conflict() file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2373, in check_version_conflict...
Read more

javascript - cocos2d-js draw circle not instantly -

i wondering how draw circles (or other shapes also) not instantly. so far tried drawcircle(args...) in ccdrawnode.js , drawcircle(args...) in cc.drawingprimitivecanvas class, , draw circles popping out instantly on screen. what if want achieve effect circular progressive bar, completes circle based on percentage of initialization? or more generally, if want draw circle respect prolonged period? thinking there drawcircle function elapsed time argument fail find any. or have implement own? thanks suggestions, far out of ideas. i think have implement own. think can achieve update circle drawing on each time update() function called.
Read more