Performance issue with the ztable.

[Former Member]

I have created a Ztable with 5 fields and generated the table maintienance. My client complains that the performance is very slow while updating or adding new entries in the table. They are doing manual entry.

Is there any measure that could be taken to improve the performance ?

[Former Member]

Hi

I dont think so we can improve the performance if many people try to update the table at a time then it will be too slow

it also depends upon your connectivity speed.

becaus of many log ins ata time will reduce the performance of the same.

from which country ur client belongs to?

Thanks

Shiva

[andreas_mann3]

hi,

how many entries ?

you can maintain ztab using sm30 with "restrict data range"

-> I think that will improve performance

btw @Shiva ,

I think always 1 person can maintain one table with sm30 and not several persons at the same time

A.

Message was edited by:

Andreas Mann

[Former Member]

How does restrict data range helps me in my issue? My table has 2 lakh entries as of now and will increase in future.

[Former Member]

While maintaining it using SM30, you can ask users to select 'Enter Condition' (Radio Button below the table name field on the screen).

This will display only selected records on the screen and this will update the process of retreival as well as updation faster.

Darshil

[Former Member]

1. Have you enabled the 'Log data changes' option to be enabled. Activating logging slows down accesses that change the table. Please check it once.

2. Have you defined the primary key for your 'Z' table.

Regards,

Ramki.

[Former Member]

Hi Team,

Thanks for all your responses. I found the reason for the slow performance.

When I execute the transaction for table maintenence, it is retrieving all the 2lakh records while displaying the initial screen. I have suggested my client that we can go for a small program which will directly update or modify the table contents. In this way we need not execute the table maintenance and retrieve all the records while displaying the initial screen.

Thank you all for your support.

Thanks,

Sivaji.

[Former Member]

most probably more than 10-20 users are logging into SM30 at a time and trying to create/change entries. This makes a lot of difference as all are trying to access database table at same time. The option is may be only 1 or 2 users need to be given the authorization to maintain the table which will improve the performance.

[Former Member]

Found the resaon.