MySQL conncurrent access

kell05's Avatar, Join Date: Aug 2008
Newbie Member
Hey, I am having problems with my database I am doing lots of queries and multiple processes on different tables. Each process is reading and editing data on different tables but it seems that the database is only giving access one process at a time. For example the time taken to perform the same query with the same amount of data has increased 100 fold (Oh I am also using transactions in my Java program). Hence my question is how do I speed up the multiple accesses??


Thanks in advance kell05
0
BargainPredator's Avatar, Join Date: Nov 2008
Newbie Member
I had a similar problem in a former project.

Since I had multiple threads in the same java applaication with all there own connection. I impleted a Connection Pool system where they shared the connections. It reduce the number of connection to the database and help a lot.

Mysql connector J comes with a pooling system. I remember I did not use it... don't remember why... But it's not to hard to code your self