Black Lives Matter. Please consider donating to Black Girls Code today.
Dash HoloViews is now available! Check out the docs.

Why Dataframe takes time when loading them through sql queries

Hello All,

I am creating a multipage app in Dash and I am trying to load the data into dataframe for further operation. The data is been loaded from SQL query into dataframe but I have seen as soon as the size increases from 50,000 the dataframe takes more time to load.

If there any alternate to it…
The command I am using is
df = pd.read_sql(sql, connection)

where sql is simple query which returns little large data.