Skip to Content
0
Former Member
Jan 06, 2012 at 08:35 AM

Transportation relations take too long to create

27 Views

Hello,

I use TP/VS for different geographical regions in the same server. The total number of customers reached 30.000, and is likely to reach 55.000 in the middle of the tear with the addition of all the regions.

I am trying to create the transportation lanes of 10.000 new customers at the moment, and it will last for almost 16 days. When we reach full capacity, an update in the map / transportation lanes will get really difficult.

We noticed that most time is spent in table u201C/SAPAPO/MODELLOC u201C, checking all the entries for evert new record.

Table buffering property for the table u201C/SAPAPO/MODELLOC u201C is set to Single Buffer Record. Should we set it to u201CFull bufferingu201D for faster access.

This table contains 30.000 Records now. But when the whole project is finished, it will contain 55.000 Records.

Any kind help is appreciated.

Best regards.