Select Statement in Smartform

[Former Member]

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.

[Former Member]

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

[christian_wohlfahrt]

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

[Former Member]

Hi

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