Code Issue

Please use a meaningful subject in future

There has been a confusion regarding the performance for fetching the data...

There are two ways to fetch the data that have been suggested to me :-

a) Using for all entries if the data is to be fetched using non-key fields or inner joins if data is fetched using key fields in where clause.

b) Using standard Function modules to fetch data, which means no joins no queries, but these FM obviously use select statements in their code and morever in most of them they use select single * that means all fields are selected not according to program need. And as its using select single , i have to use FM for every field i need to fetch that too inside a loop based on some values . That means multiple FM's in a single loop ( eventually resulting in multiple single * in loop).

<<text removed>>

Thanks

Vijeta

Edited by: vijetasap on Jun 26, 2009 7:40 AM

Edited by: Matt on Jun 26, 2009 8:05 AM - don't say it's "urg".