Why is it taking so long to load my data?Last Updated: May 02, 2019
Here are some tips to improve your data display speed:
- Reduce the number of records per page.
We generally recommend not to exceed 50.
- Reduce the number of fields displayed
You can hide some fields in your table view; this will not prevent you from seeing them in the record details view.
- Hide your relationship fields in the table view
We focus all our efforts to improve Forest Admin's performance when you navigate through your data. However, some performance issues can be related to your database architecture.
As Forest Admin generates SQL queries to fetch your data, creating indexes can improve the query response time. Indexing is a large subject but here a few tips about indexing:
- Index the Primary and Unique Key Columns
Make certain that the primary key for each table and any unique key columns that exist are indexed
- Index the Foreign Key Column
If a table contains one or more foreign key columns that reference other tables, you need to index those columns. When the foreign key column in a table is indexed, SQL Server can scan the indexes for the rows it needs instead of scanning both tables.