• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Better DB Performance

 
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 jforum.net by greggiacovelli]
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic