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.