Fetching huge data by RDB list from external DB


This is regarding the issue am facing while querying huge data from external database, in my application we generally used to query data from external database with the help of RDB Queries (RDB List) but mostly the record count reach approximately 3500 to 4000, because of the huge count of records it impacts the performance of the system ,so we have put max records (500) constraint in the RDB List so that it will not fetch huge data at once but the problem here is that we need to overdo lots of things to fetch the next 500 records as the query fetches only 500 records at one time if we are putting constraints.
Now do we have anything like OBJ list “PyMore” property in which we just have to mention the record count ex.500 and the next 500 records comes automatically by this property
Or do we have any out of box functionality in Pega to implement it.


**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

September 11, 2009 - 3:06pm

I guess you can acheive via SQL query by it self by passing count dynamically from PRPC.

September 14, 2009 - 5:26am

you can achieve this using Rownum and RowNumber(), the query need to be like this in RDB-list
Using Rownum :
select Col1,col2 from ( select rownum r,col1,col2 from table) where r > 5 and r < 11;
( to retieve rows between 5 to 11 )

and you can use RowNumber() :
select columns from ( select col1,col2, row_number() over (order by col1) r from table ) where r between 1 and 5;

check this wiki for better understanding

hopes this will help you .

May 31, 2016 - 3:32pm

Try the offset and limit of SQL. You will only have to pass the starting index i.e the offset to the SQL query , the limit can either be hardcoded or be set in DSS or can be dynamically modified , if the user has to be given this preference.