topic Hi Experts... (problem with for do an SQL test) in Application Development and Automation Discussions

Hi Experts... (problem with for do an SQL test)

Former Member — Fri, 27 Mar 2009 10:51:17 GMT

Hi people,

I need to do a SQL test in production Environment. I must optimize a SQL statement like "SELECT field_name FROM table_name.". Normally, I'm doing yhis process:

1. I make a Z program, with the SQL statement.

2. I upload the program to Test environment.

3. Finally, I upload the program to Production Environment an Test it.

I understand that this is a long way to do test (I think).

Can someone help me with another idea?

Thanks!

Re: Hi Experts... (problem with for do an SQL test)

Former Member — Fri, 27 Mar 2009 10:57:48 GMT

IN SE30 .

GO in tips and tricks.

You can paste your select query there and analyse the same.

Re: Hi Experts... (problem with for do an SQL test)

Former Member — Fri, 27 Mar 2009 11:27:44 GMT

Hi, thanks U very much, you solved my issue.

Thanks,

P.D: you deserve your ten!.

Re: Hi Experts... (problem with for do an SQL test)

ThomasZloch — Fri, 27 Mar 2009 11:44:08 GMT

This tool is usually not available in change mode in production clients ("changes to ... objects not allowed"), imagine somebody tries to measure the statement "DELETE FROM BSEG WHERE ...".

So better be careful there.

Thomas

Re: Hi Experts... (problem with for do an SQL test)

Former Member — Fri, 27 Mar 2009 21:08:27 GMT

A better way would be to do this in your QA environment (assuming it is a copy of production).

Rob

Re: Hi Experts... (problem with for do an SQL test)

Former Member — Mon, 30 Mar 2009 11:18:51 GMT

Hi friend,

This question is linked with SQL test issue.

I 've this SQL sentence:

DATA: it_ges LIKE zcctbltar OCCURS 0 WITH HEADER LINE.

CONSTANTS: l_c_si(2) TYPE c VALUE 'SI'.

SELECT z_{mandt z}guid_oportunidad z_{gestor z}tipo1 z~tipo2

z_{tipo3 z}estatus z_{prioridad z}cliente

APPENDING TABLE it_ges_

FROM ( zcctbltar AS z INNER JOIN crmd_orderadm_h AS c

ON z_{guid_oportunidad = c}guid )

WHERE z~tipo2 = 'ZAP'

AND c~zztexto27 = l_c_si.

This sentence needs 6,5 Seconds in INTEGRATION environmet (ZCCTBLTAR have 39.882 items, CRMD_ORDERADM_H have 1.853.334 items).

The problem is that I need do this process more fast than actually. In PRODUCTION environment, We have 3.179.867 items in CRM_ORDERADM_H (double than INTEGRATION).

¿Do U know how optimize this SELECT?

Thanks,

Sergio

Re: Hi Experts... (problem with for do an SQL test)

Former Member — Mon, 30 Mar 2009 16:26:35 GMT

Hi friend,

This question is linked with SQL test issue.

I 've this SQL sentence:

DATA: it_ges LIKE zcctbltar OCCURS 0 WITH HEADER LINE.

CONSTANTS: l_c_si(2) TYPE c VALUE 'SI'.

SELECT z_{mandt z}guid_oportunidad z_{gestor z}tipo1 z~tipo2

z_{tipo3 z}estatus z_{prioridad z}cliente

APPENDING TABLE it_ges_

FROM ( zcctbltar AS z INNER JOIN crmd_orderadm_h AS c

ON z_{guid_oportunidad = c}guid )

WHERE z~tipo2 = 'ZAP'

AND c~zztexto27 = l_c_si.

This sentence needs 6,5 Seconds in INTEGRATION environmet (ZCCTBLTAR have 39.882 items, CRMD_ORDERADM_H have 1.853.334 items).

The problem is that I need do this process more fast than actually. In PRODUCTION environment, We have 3.179.867 items in CRM_ORDERADM_H (double than INTEGRATION).

¿Do U know how optimize this SELECT?

Thanks,

Sergio

Re: Hi Experts... (problem with for do an SQL test)

Former Member — Mon, 30 Mar 2009 18:15:00 GMT

Sergio - since this question is both marked as solved and in the wrong forum, you are unlikely to get a lot of discussion. My advice is to ask it again in the performance and tuning forum.

I should also add that you should include a link back to this thread, so that people can see what was proposed earlier.

Rob

Edited by: Rob Burbank on Mar 30, 2009 2:17 PM