Navigation |
![]() ![]() ![]() |
If you define values for itemsPerPage and pagesPerBlock sub-elements of RelDBQueryDataService and the query returns big amount of records then the navigating on the data source may keep the users waiting for several seconds. The Reason: This is because, each time a navigation request is received, a new JDBC connection is obtained and a query is executed. After the desired part of the result set is taken, the result set and the connection is released along with the Http Request. For the next navigation request the same actions are taken again and depending on the type of the data base this can be very time consuming. The Solution: To avoid this you can tell the RelDBQueryDataService to keep the result set and the connection for a period of time so that if the user makes another navigation request before the timeout the data service can make use of the kept result set and thus responds much quicker to the request. Set the refreshTimeOut sub-element of the data source to activate this feature. You should be aware that this feature may consume big amount of memory and therefore you should keep the refresh time out value as short as possible.
|