topic Re: performance problem in Application Development and Automation Discussions

performance problem

Former Member — Tue, 27 Jun 2006 13:49:45 GMT

i made this comma

DATA : zins LIKE ztable.

INSERT ztable FROM zins.

this takes a lot of time (se30)

why?????

Re: performance problem

LucianoBentiveg — Tue, 27 Jun 2006 14:45:49 GMT

Try with:

INSERT INTO ztable VALUES zins.

Regards.

Re: performance problem

Former Member — Tue, 27 Jun 2006 14:54:56 GMT

hi rani,

INSERT dbtab FROM wa. or

INSERT (dbtabname) FROM wa.

Inserts one line into a database table. The line to be inserted is taken from the work area wa and the data read from left to right according to the line structure of the database table dbtab. Here, the structure of wa is not taken into account. For this reason, the work area wa must be at least as wide (see DATA) as the line structure of dbtab, and the alignment of the work area wa must correspond to the alignment of the line structure. Otherwise, a runtime error occurs.

If the database table dbtab or the work area wa contain strings, wa must be compatible with the line structure of dbtab.

When the command has been executed, the system field SY-DBCNT contains the number of inserted lines (0 or 1).

The Return Code is set as follows:

SY-SUBRC = 0:

Line was successfully inserted.

SY-SUBRC = 4:

Line could not be inserted since a line with the same key already exists.

Example

Insert the customer Robinson in the current client:

DATA: wa TYPE scustom.

wa-id = '12400177'.

wa-name = 'Robinson'.

wa-postcode = '69542'.

wa-city = 'Heidelberg'.

wa-custtype = 'P'.

wa-discount = '003'.

wa-telephone = '06201/44889'.

INSERT INTO scustom VALUES wa.

Re: performance problem

Former Member — Tue, 27 Jun 2006 14:59:41 GMT

are you sure?????????

Re: performance problem

Former Member — Tue, 27 Jun 2006 15:06:42 GMT

hi rani,

u can also give

DATA : zins LIKE ztable occurs 0 with header line.

INSERT ztable FROM table zins.

Re: performance problem

Former Member — Tue, 27 Jun 2006 15:13:53 GMT

u can also add 'accepting duplicate keys' to avoid short dumps.