topic Re: Client Specified in Application Development and Automation Discussions

Client Specified

Former Member — Wed, 20 Apr 2005 04:46:56 GMT

Does the use of 'client specified' in open SQL statements improve the performance of SQL statements.

Re: Client Specified

Former Member — Wed, 20 Apr 2005 04:49:47 GMT

No. It does not.

In fact, if you use <i>Client Specified</i> and specify clients other than SY-MANDT, the performance may worsen.

Re: Client Specified

ssimsekler — Wed, 20 Apr 2005 08:35:19 GMT

I agree with Anand that it will not do any performance optimization.

However, I am not sure whether it may worsen the performance since it just disables automatic client handling. Anyways, this is in fact not so much in context of the main question, besides the question is answered.

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Re: Client Specified

Former Member — Wed, 20 Apr 2005 08:37:05 GMT

Hi Raghuram,

You can prove this to yourself.

You can test the performance of statements side by side using the Performance Tips and Tricks transaction. From SE80 go to Environment->Examples->Performance Examples.

Type in your two select statements (one with client specified and one without) in the two windows and hit the measure runtime button. If you have a reasonable amount of data you should be able to tell any difference. Although as Anand says, I don't think you'll see any.

Cheers,

Brad

Re: Client Specified

Former Member — Tue, 31 May 2005 11:09:51 GMT

Hi Brad,

Thanks for the reply, but what i also wanted to know was which would be better simply giving a delete statement or use a delete with a client = sy-mandt

Re: Client Specified

Former Member — Tue, 31 May 2005 14:05:15 GMT

I think you should use automatic client handling unless you actually want to delete data in a different client from the current one.

There is no use of specifying client = sy-mandt .

Thanks,

Ram