Improving perfomance loading info from tables

russianyaz · Post by **russianyaz** » Mon 18 Jun 2007 13:43

Hello,

I'm new using ODAC components, some months only and I've discovered a bright vew world on using Oracle with Delphi.

I'm using ODAC version 5.70.0.29 for Dephi7, Oracle 9.0 and Delphi 7. In the appl I'm working on I need to dump into memory several tables that are used often in the appl so later I can access the info quicker. I can't find something similar to the InMemory procedure present on the TTable class of the usual DB delphi components.

I'm missing something? Do the ODAC components have something similar? Or I need to build it all up from the start. I mean, create new classes, procedures, etc.

Thanks in advance for the answers....

PS: sorry if my english is not too good, hope the question is clear enough

Plash · Post by **Plash** » Mon 18 Jun 2007 14:17

Set the FetchAll property of the TOraTable component to True. In this case all table data will be fetched into the memory when you open a table.

russianyaz · Post by **russianyaz** » Tue 19 Jun 2007 07:25

Thanks...I'll try this option...I was thinking in a very different approach, maybe a list of JfDbGrids...