#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2009
    Posts
    4
    Rep Power
    0

    Speed up database access


    We have a Sybase database which we regularly connect. Recently we started to build multithreaded applications, and the connections to the database started to increase. There are several applications connect to same database some c++ executables through RougeWave libraries, and many Matlab toolbox connections, and perl, ruby scripts.

    I am thinking if there is another layer of interface that is used to receive data (maybe even control the writes to DB), data access might be faster. This interface code should make the connections to database and to the applications, but applications should not directly query the DB. This interface code should cache the data queries that are regularly requested, and might need to run multithreaded to respond multiple requests at the same time, but use a single cache.

    I have actually heard this kind of caching is common for high volume database connections. Are there any open source examples??
  2. #2
  3. Moderator Emeritus
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2002
    Location
    Austin, TX
    Posts
    7,183
    Rep Power
    2220
    Hibernate is a Java ORM interface to databases, which leverages quite a bit of caching to minimize database access. You might glean some ideas from analyzing how Hibernate facilitates this.
    DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Connect with me on LinkedIn
  4. #3
  5. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2010
    Posts
    4
    Rep Power
    0

    Re:


    Nice information.

IMN logo majestic logo threadwatch logo seochat tools logo