Hi,
I run a Web application that constantly imports data to my DB. This import
thread brings lots of reads and writes to my DB. The same Web application sends user requests (user search queries from a website) to the DB.
Problem: user requests get slower due to reads and writes to the DB by the import thread.
I wonder if I could assign a certain limit of e.g.
JDBC maxThreads for each of the processes to control the performance for both processes separately. For example, does it make sense to configure two JDBC resources (connecting to the same DB) with limited maxThreads set for the import process to keep DB performance for the user requests?
Thanks for any input on this!