This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Better DB Performance  RSS feed

Migrated From
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I have been working with JForum now for a few months. I see the features built as very useful however I see some performance bottlenecks which I would like to see them be addressed.

My bias is currently with Mysql, but I am sure many of the other DB installations could benefit from this as well.
Since this is a heavily data driven system with a really high read rate and a lower write rate (don't get me wrong it's high but not as high as the reads), would it be possible to make changes to split the queries into 2 connection pools? (one for read and one for writes/or complicated queries involving both)

This will considerably reduce the amount of DB contention with something like mysql. running mysql in a master slave setup would allow you to connect to one of N slave for reads and write to a single node that would be replicated to the slaves. However currently in the way JForum is constructed this is not possible.

This could easily be abstracted with the DataAccessDriver or another entity which would bind the query to a connection. In cases where a DB implementation doesn't benefit from this type of optimization, we can just use 1 connection pool. And it has no impact whatsoever at that point.

Does this sound valid?
[originally posted on by greggiacovelli]
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!