database swap to RAM

Posted on 2005-05-06
Last Modified: 2010-05-18

I am using SQL to access the tables of a database (MS-SQL, MS-Access). The frequent calls take a long time so I would like to transfer some tables with the most frequent calls to RAM.
Any idea how to swap some tables to RAM ?  I want to use the same SQL-statements and just change the ADOConnection !

K.-P. Becker
Question by:KPBecker
    LVL 15

    Accepted Solution

    Hi again KPBecker,

    The only thing I have used to store tables data outside of an ADO object is by using a component/unit I have called a TXMLTable.
    It basically works in the following way ...
    1) use an ADOQuery object to retrieve all the data from a table you need
    2) assign TXMLTable.Dataset := ADOQuery. This stores all the data in a format I can use to search by fieldname, eof etc etc.
    3) you can then free the ADO object and store some global TXMLTables that will now be available for the lifetime of the application, or until you update the data.

    If this is of help to you I could post the unit here for use.

    Author Comment

    Hi Mike,

    I am not quite sure if I understand how your suggestion works.
    Any experience with client-datasets ?

    Up to now I read the database-table into an array and seek by program, but this is very specific in every new case.

    K.-P. Becker


    Author Comment

    Hi Mike,

    it would help if you could post this unit !

    K.-P. Becker

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
    Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now