topic Re: Whole Data Retrieval in Application Development and Automation Discussions

Whole Data Retrieval

Former Member — Tue, 22 Jul 2008 12:41:32 GMT

Hi Experts,

I have one master table, which contains about 16million records. My scenario is to retrieve all the data from the master table and display it using report. I am getting request time out error, when I use select statement. Can anyone tell me the other options to retrieve the whole data?

Regards,

Harish

Re: Whole Data Retrieval

bpawanchand — Tue, 22 Jul 2008 12:46:31 GMT

you can go for CURSORS rather than directly using select statement.Using secondary indexes also you can acheive this

Regards

Pavan

Re: Whole Data Retrieval

Former Member — Tue, 22 Jul 2008 12:47:47 GMT

what is ur select syntax? how are u trying to display the data???

Re: Whole Data Retrieval

Former Member — Tue, 22 Jul 2008 12:48:53 GMT

Hi Pavan,

Can you give some example coding?

My coding is ,

Select fld1 fld2 fld3 fld4 fld5 fld6 from tab1 into inttab where fld1 in fld1.

Regards,

Harish

Re: Whole Data Retrieval

Former Member — Tue, 22 Jul 2008 12:51:53 GMT

User Package size option.

Assume 100000 is package size , the every time it gets 100000

first time

100000

second time

100001 to 200000

....

Select some number of recorda and process it and then fetch from the count where you stoped before.

or Schedule Backgrond job.

Re: Whole Data Retrieval

Former Member — Tue, 22 Jul 2008 12:52:16 GMT

hii harish

use maximum keys to retrive data from table with select statement.

regards

twinkal

Re: Whole Data Retrieval

Former Member — Tue, 22 Jul 2008 12:59:07 GMT

Hai Patel,

how can i use keys in select statement to retrieve more than 1000000 records?

Regards,

Harish