MySQL Forums
Forum List  »  Connector/JDBC and Java

Re: Java and mysql high concurrency bottlenecks solutions
Posted by: Frwa Onto
Date: June 26, 2017 11:15PM

Dear Silva,
Well my insert queries will be not be same that is for sure. So should I set cachePrepStmts=true . Yes all my sql are prepared statement. Currently I research and looks like HikariCP is a good pooling solution what is your opinion on this? As for the tcp communicator I am planning to spread the load across meaning each server will handle around 5K of devices but the database will be on central db. I am also looking into the bulk insert but before that I still need to run few sql select and update then I planning to pipe the insert into queries that as one of the options.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.