Archives of the TeradataForum
Message Posted: Wed, 06 Apr 2016 @ 20:56:00 GMT
We are on TD 15. One of the tables in our application is accessed by multiple users at the same time. However up until now, the inserts were very fast and we never noticed the blocking, however now after enhancing the application for more features, the inserts are taking longer and it is causing contention. My question is without re-architecture, is there any way we can avoid this?
The exact issue is - The application runs for different scenarios and inserts the records in one final table. So I need to figure out a way to avoid the blocking when multiple users are running scenarios and inserting records to that same final table. I was thinking in terms of creating the final table as GTT, however I need to get the records for all the scenarios run by users (from different sessions) to the final table in order to do further processing, which cannot be achieved if I use a GTT table.
I also thought of creating the table a NoPI so that the inserts are faster. Are there any other ways here?
Any ideas here will be a big help.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|