topic Re: fetching data from a big database view in Application Development and Automation Discussions

fetching data from a big database view

Former Member — Tue, 27 May 2008 10:39:26 GMT

I have a database view of four tables viz.,EKKO ,EKPO, EKBE, LFA1.So, when I retrieve the data from this view the application hangs or stops responding means this particular query which is fetching the data from this big view gets stuck somewhere.How to get around this problem?

Thanks and regards

Mr.Sonal Sharma

Re: fetching data from a big database view

ritesh_dugad2 — Tue, 27 May 2008 10:46:50 GMT

Pls. check your Join conditions in the view, hope they are correct. Other way is to write select statements using Joins/for all entries/into table etc.

Re: fetching data from a big database view

Former Member — Tue, 27 May 2008 10:47:19 GMT

yes it will take time if data retrived for selection will be high in volume.

insted of that u can start ur selection from EKKO , and can use SELECT FOR ALL ENTRIES to select data form other tables .

INNER JOIN or VIEW's for big selection condition (WHERE condition decrease performance of report)

reward if helpful.

Re: fetching data from a big database view

Former Member — Wed, 28 May 2008 09:23:34 GMT

hai,

send the piece of code you are using for data access.

check out for performance in sap hel also.

regards

jase

Re: fetching data from a big database view

Former Member — Tue, 03 Jun 2008 16:56:57 GMT

Hi,

Try to use criteria with key field,

If program return a huge data, Try to run in background!

More info about performance tuning http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Cheers

Wiparat