Improving performance for fetching data from the database

By default, the resultset fetch size parameter in Smarten is set as 0. So it will fetch all the records in one resultset from the database. In such cases, there are chances of high memory utilization that may lead to performance problems. Also, if there is any connectivity issue or any other interruptions that may occur in between this data extraction process, the extraction will be stopped. And when the connection gets back, it starts the extraction from the scratch again.

To resolve such issues, Smarten provides parameter of “ResultSet fetch size” that allows the user to set the resultset size. For example, if the size is set as 1000, it fetches the records in 1000’s set.

To set this parameter, 

Procedure:

1. Open the datasource list and edit the datasource.

 

 

                                DATASOURCE EDIT OPTION

 

2. In the datasource profile,the option of ResultSet fetch size will be displayed as the last parameter.

 

                                                DATASOURCE PROFILE

Click OK after setting this parameter.

Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten version you may be using.

 

Dataset Datasource Datasource Profile performance Fetch size ResultSet ResultSet fetch size