This isn't really a Mina question. Seems like you need to work on some tests to find out what parts are the bottleneck. I don't know why a buffer would mean faster inserts. Buffers are good to offload the tasks to other threads and that has its own performance advantages depending on how your database driver works. On Jul 15, 2014 5:11 PM, "Eray Yuksek" <[email protected]> wrote:
> Hi, > > I am new in the list so I am not sure if I am sending my question to the > right list since I know that there is another list called > [email protected]. > I apologize in advance if this is not the right list and in that case, > please let me know. > > Here is our problem: > > We try to handle thousands of concurrent connections through Mina, and > what we do is that we put all of the messages goes through Mina > successfully into a buffer with size 10K and then one by one we get the > messages from the buffer and insert into single sql server table. However > under heavy load, our inserts into the database table slows down > significantly. We actually had no buffer before but at that time, it was > even worse to insert all those concurrent messages right away into the > table. We thought buffer would give us time to store the data under heavy > load and we could get the messages one by one from the buffer and insert > into the DB. But nowadays, even buffer is not enough for us. > we are not sure whether the buffer is holding us back or the DB inserts > but somehow we have to find a way to insert all the concurrent messages > into that one DB table. > (the buffer we are using it BoundedFifoBuffer and we use it as > synchronized buffer) > > > Thanks for your help in advance. > > Eray Yuksek > > > E.Y.
