topic Re: Logical Database vs Database tables in Application Development and Automation Discussions

Logical Database vs Database tables

Former Member — Fri, 04 Sep 2009 04:32:38 GMT

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

Re: Logical Database vs Database tables

former_member188827 — Fri, 04 Sep 2009 04:36:23 GMT

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.

Re: Logical Database vs Database tables

Former Member — Fri, 04 Sep 2009 04:39:12 GMT

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

Re: Logical Database vs Database tables

Former Member — Fri, 04 Sep 2009 04:57:19 GMT

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%20teched%202006/premium%20content/cd/cd356%20state-of-the-art%20abap%20-%20a%20practical%20programming%20guide/cd356.pdf

Hope this helps.

Thanks,

Samantak

Re: Logical Database vs Database tables

Former Member — Fri, 04 Sep 2009 05:16:54 GMT

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.