@Tejaswini_Yarramanen Hi Tejaswini, I assume you’re working with a SQL table. The first highlighted row in the screenshot is the process of reading raw data directly from the SQL table. This took almost 6 seconds. The second highlighted row from the screenshot is the process of converting the raw data fetched from the database to a format that can be used by AppSheet. This took 11.5 seconds.
The second step took such a long time is because AppSheet is not a dedicated SQL platform. Since AppSheet has to work with not just data from SQL databases but also Google sheet, excel files, etc., our server cannot be optimized to process raw SQL data as fast as dedicated SQL databases do.
The best way to reduce the time taken is to reduce the number of rows that will be fetched directly from the database. This will reduce both the time spent reading the rows as well as the time spent processing them. To reduce the number rows fetched, you either use a security filter in AppSheet, or hook your AppSheet table to a SQL view instead of the whole SQL table.