Dose anyone know how Delphi app. runs data from .db files (Paradox 7/Delphi 7).
Dose it?, load the table file (.db file) in RAM.
Or dose it?, read it from the HD when needed.
What I am looking for - is:
If I have a XXXLarge table (.db) file. Will the hole file be read in to RAM (then I need more RAM :?) )
My good faith tell's me that it load the Index/Primery keys in RAM and when needed gets data from HD.
Related question: If i use TQuery with different tables(.db) during the program (not at the same time) will all the tables be loaded into (RAM? related to the first question) at app. load.
I am having problems with finding the info I need. I have tryed google.
Sorry my difficult setup of the question and my english. Hope somebody can help.