fetching records

[jackieblue75]

what is the quickest way to fetch 100K or more records into a DBGrid? NOTE: in TOAD, the data returns in (4) seconds - using a TOracleDataset, the data takes much longer.

 

[Marco Kalter]

If you must use a TDBGrid, the TOracleDataSet is your only option. If you can use other grid components, you can use a TOracleQuery or a UniDirectional TOracleDataSet to optimize memory usage.