If you are having trouble fetching 100k+ records into clientdataset, and you are still bound to Delphi7, FastMM + Midas patch can give a huge performance boost.