• Post Reply Bookmark Topic Watch Topic
  • New Topic

Creating a DB Framework  RSS feed

sandy gupta
Ranch Hand
Posts: 228
  • Mark post as helpful
  • send pies
  • 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
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!