Originally Posted by andbin
Thank you for reply.
All stated questions are valid. The application in front communicates towards various systems via Radius or Diameter. Depending on config there can be multiple interfaces or just one, by each interface one thread. In any case, since this are highly transactional systems which can go to 400 TPS per interface and DB output is limited only to 1 thread or better to say 1 FIFO stream for writing to it.
I haven't think about communication since this will be just challenge for me. But let's say that DB to which I'm writing is on other server and the inserts are simple. 30 - 50 values per insert, no updates or complicated stored procedures behind it. And I'm planning to use no third party extensions.
I know this is big peace of cake for me right now, but that is I would like to have systematic path of progress and also to have some pointers in which direction to go.