topic Re: Performance in Select statement in Application Development and Automation Discussions

Performance in Select statement

Former Member — Wed, 17 Sep 2008 10:45:17 GMT

I have to retrieve all records from VBFA table.

SELECT <fields> from VBFA into table t_vbfa.

no condition is there to place in where condition.

how can i improve the performance.

Thank you.

Lalitha

Edited by: lalitha botla on Sep 17, 2008 1:11 PM

Re: Performance in Select statement

former_member755502 — Wed, 17 Sep 2008 11:12:31 GMT

Hi,

As you have mentioned that there is no condition for selection, in that case make sure that you don't fetch any un-necessary fields. Also, store the selection result in some internal table for further usage as executing these kind of queries (databse fetch) repeatedly is not wise.

Thank you.

Re: Performance in Select statement

Former Member — Wed, 17 Sep 2008 11:18:32 GMT

I am taking only required fields( only five fields ) and storing

the selection result in internal table t_vbfa.

Re: Performance in Select statement

Former Member — Wed, 17 Sep 2008 11:25:54 GMT

better u will give blank ranges and

client as restriction parameter

Re: Performance in Select statement

former_member70391 — Wed, 17 Sep 2008 11:29:05 GMT

Hi Lalitha,

Instead of writing select query you can use FM SD_VBFA_SELECT, I think this would be faster compare to select query.

Just compare your report with this FM.

Thanks & Regards,

Nagaraj Kalbavi

Re: Performance in Select statement

Former Member — Wed, 17 Sep 2008 12:09:41 GMT

can you please explain me about blank ranges?

does it affect the performance?

Re: Performance in Select statement

Former Member — Wed, 17 Sep 2008 13:35:46 GMT

Run it in the background. There's not much you can do.

Rob

Re: Performance in Select statement

Former Member — Thu, 18 Sep 2008 05:23:12 GMT

Hi Lalitha,

use package size in select statement with appending option or in to option according to your requirement to store all the contents of vbfa table in to an internal table.

Use the following link which helps you to write a query using package size.

http://help.sap.com/saphelp_scm50/helpdata/en/fc/eb39eb358411d1829f0000e829fbfe/content.htm

Thanks,

Naveen Kumar.

Re: Performance in Select statement

Former Member — Thu, 18 Sep 2008 09:34:51 GMT

Hi,

why?

What do you think the FM is doing ? It will execute SELECT to the database.

(It may somewhat little slower if they do it in a loop)

You can't beat a SELECT like that. If you can do it in one statement - do it!

For a real boost you can have some database hints like PARALLEL or for database buffering.

but...the database has to support it, your DB server has to have enough resources and sometimes it makes

no sense to do in PARALLEL because of the tradeoff between the coordinating of parallel processes and the amount of rows to be selected.

bye