Win a copy of Terraform in Action this week in the Cloud forum!
  • 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Creating a DB Framework

 
Ranch Hand
Posts: 228
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am working on Creating a DB Framework for Read Only Information and i would like to share some of the points that could be really helpful which have come up from the 3 days of research that i have put into it thus far.......I hope the next week and a half will yield even more information...............
I would really appreciate if some one would like to add their thoughts as to how i could make this better.
To Create a DB framework that is efficient as well as non-resource and CPU intensive, i will be using
a) Cached Prepared Statements: This is a feature that the Weblogic 7.0 provides in which the connection pool will cache the prepared statements so that the next time the same statement is executed on that pool, the overhead of preparing and parsing a statement is avoided. Will have to watch out for overkill in this case
b) Start Up Classes for Static DB Objects: Planning on getting some start up classes which will act as a cache for my static DB objects which are frequently accessed and hardly changed.
c) Of Course Connection Pools: What i plan to do is to get the handle to all the connections in a pool and then distribute them to applications and when the connections seem to be getting over, i use an asynchronous call to increase the connections and store them. I do not know for sure whether this is a good idea to be implemented. Advice.
d) Providing an API for functions that will let the users of this f/w get the RS for some of the generic methods and a control over the DB to an extent.
This is all that i could come up with till now...........Any more will be welcome
Ciao
 
reply
    Bookmark Topic Watch Topic
  • New Topic