How to show specific number of records from billion of records.

[deepakqlikview_123]

Hi All,

Below is scenario.

I have 1 table containing 10 billion records, but as per client requirement I just need to show 100 records at a time.

But in this case all records should presnet.But for processing whole data it is taking a lot of time and giving performance issue.

Can you please suggest how shall I proceed in this case.

Thanks,

Deepak

[rajeshvaswani77]

Hi Deepak,

Can you give more details?

What do you mean when you say

But in this case all records should presnet.But for processing whole data it is taking a lot of time and giving performance issue.

thanks,

Rajesh Vaswani

[deepakqlikview_123]

Hi Rajesh,

As per requirement we are using straight table for doing some calculation and showing data in tabular format.

In straight table it should display records like 1-100 then 101-200,201-300  till maximun record size.

In this way all records should be there at output level.

But when I am trying to reload whole data it is taking lot of time even I am not able to view all of those data at dashboard level.

Thanks

[deepakqlikview_123]

Hi all,

Can you please give any any suggetion on this, please help me out.

Thanks,

Deepak

[jagan · Accepted solution]

Hi Deepak,

Check this link, hope it helps you.

Paging Implementation for Straight table

Regards,

Jagan.

[deepakqlikview_123]

Thanks Jagan,

That is really helpful hor me

Thanks,

Deepak