E
etl2016
Guest
hi,
I have spun nearly forty threads in my application, all threads accessing the DB through Thread Lock feature. Each thread is processing an estimated hundred thousand rows. I am getting DB timeout errors. I have used connection pool mechanism. I want to take a closer look and identify one of the three possible reasons.
One, the DB is not efficient enough to handle calls within a given thread (because, thread lock is already in use). If so, its connection features (or similar) need an upgrade. The connection is getting timed out in 5000ms.
Two, the thread lock is not implemented correctly.
Three, connectionpool is not implemented correctly. How do I programmatically diagnose the actual reason to pin-point the root cause?
thank you
Continue reading...
I have spun nearly forty threads in my application, all threads accessing the DB through Thread Lock feature. Each thread is processing an estimated hundred thousand rows. I am getting DB timeout errors. I have used connection pool mechanism. I want to take a closer look and identify one of the three possible reasons.
One, the DB is not efficient enough to handle calls within a given thread (because, thread lock is already in use). If so, its connection features (or similar) need an upgrade. The connection is getting timed out in 5000ms.
Two, the thread lock is not implemented correctly.
Three, connectionpool is not implemented correctly. How do I programmatically diagnose the actual reason to pin-point the root cause?
thank you
Continue reading...
