We currently have a big Transactions Table with 9200 rows. The data grid is limited to 100 rows, and works fine. However when trying to use the search bar for certain customers, the data just will not load. Gets stuck on loading, then either tells them no connection or loads no rows. Same thing happening in the builder
1 Like
hi @MattGlides , can you share a screenshot of your customer’s detail screen?
also, how many computed column do you have for this table and how many of them are visible on the data grid collection?
please note that the best way to optimise search for a collection sourcing info from glide big tables is to ensure that all the column values you want to search by are stored statically (in basic columns - text , number etc) and also ensure they are present is some way or the other in the detail screen.
what i usually do is have a new container in my detail screen and name it “search string”. inside this cotainer, i add a field component with all of the static columns i wanna search with.
then with a visibility condition for this container.. something like “row ID = abc123”.. i hide the container so the user does not see nonsense data
once this is done your search should be much faster as glide big table search searches throgh any and all data present in that records detailed screen.
hope this helps 
1 Like