Search code examples
pandasnumpyquandl

Quandl response extremely slow on my home network as opposed to my mobile WIFI hotspot network

As stated in the question, something weird is happening. My quandl code:

import quandl

df = quandl.get('WIKI/GOOGL')
print(df.head())

Responds after a few minutes on my home network, however if i connect my laptop to mobile WIFI hotspot, it responds in seconds.

I am truely perplexed as to the cause of this issue

Solution

  • Apparently Quandl python module is having issues where IPV6 Protocol connectivity is supported along with IPV4. By disabling IPV6 connectivity on my ubuntu machine, the data response is prompt and normal.

    Steps to disable IPV6 in ubuntu:

    Edit the sysctl.conf file as follows:

    sudo gedit /etc/sysctl.conf

    Append the following lines at the bottom:

    net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1

    Restart the systcl.conf file or reboot:

    sudo sysctl -p

    Happy mining! =D