1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

A question about accessing database by an application

Discussion in 'General' started by virusx1984, Feb 27, 2011.

  1. virusx1984

    virusx1984 Active Member

    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    80
    When a program needs to get data from a database frequently, should I move all the data I'll use from the tables of the database to the memory rather than fetch it every time I need it by executing query in the program?

    But If I move all the tables of the database to the memory, how can I execute the strings of sql-like syntex to create a new table I need?

    What is the appropriate way of storage of data from database in the memory that can use sql-like syntex to query data?
     
  2. bdtagar

    bdtagar Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,
    If you are using Java then go with Hibernate.
    Bye