cancel
Showing results for 
Search instead for 
Did you mean: 

SARI performance issue

Former Member
0 Kudos

Gurus:

We have some infostructures that are very slow when loading data into it.

Is there any tip to improve the performance?

And how to estimate the time needed to load into a given infostructure?

Thanks a lot!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Laura

I notice that you have not received response on your question and although 10 months later, I might be able to contribute, even if its just to share information about optimizing the use of info structures.

First relevant point is that we must remember that when filling an info structure, we are copying archived data back into our live system and needless to say that we have to be very selective with choosing the fields for our info structure. Not only does the number of fields play a role in the size of the info structure, but also which fields we select. Therefore always a good idea to be aware of the field lengths (which can be seen from SE11) and to avoid filling text fields, which could be anything between 50 to 150 CHAR. The volume of data being filled will therefore play a role in the duration of the filling process.

The second point to consider will be the time of the day chosen to fill the info structure. The communication channel between the archive server and your production server can only optimally handle so much traffic and its always better to fill info structures when no archiving is in progress. We will agree that after working hours will also increase the filling performance, but we often forget that many background batch jobs are scheduled during these "quiet" times. Find the "gap" when the system is least busy.

The third important point is the number of key fileds in the field catalog we choose, or create. The key fields create an index for the info structure table and again the archived data is duplicated during the filling process.

Lastly we have also found that in SARA - Customizing - Cross-Archiving Object Customizing - Technical Settings - Verify Archive Files, performance is improved when both "Before Reading" and "Before Reloading" is unticked.

Hope this helps