Hello guys, I developed a streamlit code to pull data from database of about 200k records but it loads for a while and when done , it breaks disconnects and closes before displaying summary of the data. Am not sure whats wrong because 200k dataset is so small to crash the app. Anyone experienced this and how can I solve the problem.
Here is a snippet of code pulling data and displaying. I personally dont see any problem with the code:
#import packages import streamlit as st import redcap from redcap import Project import pandas as pd import numpy as np st.title("Monthly Mortality Reports") #add_selector for Hospitals add_selector = st.sidebar.selectbox("Select hospital facility to view report","MMLY") @st.cache def pull_data(): api_url ="add database url" api_key = "add project data key" project = Project(api_url, api_key) df = project.export_records(format='df') return df data = pull_data() st.write(data)