Logical Database vs Database tables

[Former Member]

Hi,

To extract some information in a report program, currently we are making use of a Logical Database . But we see that the performance is very poor and we believe , a direct read from the database tables should improve the performance.

We are looking for some supporting documents which confirms the same. (A direct read from the database tables gives better performance than reading from a Logical database). Any points will be highly appreciated.

Thanks a lot.

Regards,

Suganya

[former_member188827]

This depends on data which you are trying to read.If you need data from a node in LDB,which is deep down,direct read of table will give better performance since LDB has a read sequence for nodes.So it will read all the nodes that come in the path of node you are trying to read.

[Former Member]

Hi,

Thanks for your answer. We proposed this solution to our clients but they are asking for some supporting documents which confirms the point. Do we have any pointers to this?

Regards,

Suganya

[Former Member]

Hi,

As per the recent ABAP Programing Guidelines, the use of the Logical Database is highly discouraged.

You can have a look at the guidelines at the following link :

http://www.sap-press.com/product.cfm?account=&product=H3072&shoppingcart=003

Th official Programing Guide cna be locate at

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/com.sap.km.cm.docs/media/streamingmedia/events/sap...

Hope this helps.

Thanks,

Samantak

[Former Member]

Hi,

Pls go thru the disadvantages of LDB [here|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5981] [original link is broken] [original link is broken] [original link is broken];

The performance depends on the number of tables in the LDB and the node read.

Alternatively go through [this|http://help.sap.com/saphelp_47x200/helpdata/en/64/237f8cd43711d1950b0000e8353423/frameset.htm] which calls LDB by an FM specifying the tables.

a note on [performance|http://help.sap.com/saphelp_47x200/helpdata/en/f0/ca4584260211d28a430000e829fbbd/frameset.htm] of LDB.

regards,

Teja.