Active DataWahouse

Database
Enthusiast

Active DataWahouse

We have a requirement where we have to support more than 100 jdbc sessions inserting nearly 1000 rows per second.

Can you please help em with best pracitces for implementing something like this.

1: Would a PPI based on source key help (My guess is no ,Since it would only be useful while retreival )

2: Is it neccessarry to change jdbc and use TPT or Tpump instead.

3: Would making tables as NoPi help avoiding contention/deadlock ?.

Tags (1)