Improving performance for fetching data from the database

Modified on Thu, 14 Mar 2024 at 12:29 PM

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, 


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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article