Returning large data from query in small batch

Question

Hello, looking for some help. 
 
 I have a requirement to query a database for a customer that has over 7,000 rows. 
 When I run the query, to return 7000 rows, it fails (obviously too much) 
 Is there a way to query for the 7000 rows but only query and load 15 or so at a time? And when the user clicks the next arrow on the paging grid, it only loads 15-30? So that the interface isn't overloaded? 
 They aren't going to page through 7,000 records, 15 at a time, but the requirements still want to be able to have an overall customer view. 
 Thanks,

Colton Beck · Answer

Yes, add appropriate paging info to your query. 
 You should never configure a query to pull back all data, as this is not a scalable design paradigm. Set the paging info batch size to some reasonable number, like 10 or 20, and you should have better results.

Puspendu Pal · Answer

Hello, 
 
you can use Paging Grid to display the records and then when the user clicks on the next or previous links on the paging grid the system would know what to do. 
 
For more details look into below link. 
 
 docs.appian.com/.../Paging_Grid_Component.html

aloks0189 · Answer

Hi joh4 I believe you need to explore paging grid SAIL recipe to understand the SAIL component properly. 
 
For quick reference, you can have a look on this link mention below: 
 docs.appian.com/.../recipe_display_array_of_data_in_a_grid.html 
 
Hope this will help you.

Aparajita Singh · Answer

This is the best way to reduce the time the query takes to execute. Please also add selection if you do not want to use all the table columns.

Returning large data from query in small batch

Top Replies