topic Re: Select Statement in Smartform in Application Development and Automation Discussions

Select Statement in Smartform

Former Member — Thu, 21 Dec 2006 04:36:45 GMT

hi all,

I am running VF03 to get the output of Invoice and i am writing Select query inside the Smartform. Is there any performance issue and also is it mandatory to use select querey only in the driver program.

Let me know based on the performance analysis.

Re: Select Statement in Smartform

Former Member — Thu, 21 Dec 2006 04:39:29 GMT

Hi,

Should be okay to have SELECT statement in Smartforms..

Performance depends on which table you are accessing and how many records it will be fetching..

Thanks,

Naren

Re: Select Statement in Smartform

christian_wohlfahrt — Thu, 21 Dec 2006 08:54:19 GMT

Hi!

A select in smartforms is as fast (or slow) as in the driver program. As long as you didn't add the select in a bad place like inside a loop, there is no principal performance disadvantage.

Also from philosophical point of view both is possible: some like smartforms which have only NAST-key as input and make all selects in the smartform (very easy testing!), other prefer the selection logic in the driver program. Again: both is possible and good.

Regards,

Christian

Re: Select Statement in Smartform

Former Member — Thu, 28 Dec 2006 19:31:34 GMT

You can use select statements in Smartform. See that you are:

1. Not having select statements in loops.

2. No select...endselect stmnts...

3. No redundant selections on same tables.

As far as possible try get all required data at one go...

Qualify to the maximum extent your select stmnts (giving all possible key fields in where clause)

Regards,

Raj