RE: BDE performance

[Alexander Liffers <alex@tmp.com.au>]

One big performance increase I find, especially with paradox and dbase files, is using cached updates... i.e.

TTable* mytable = new TTable (0);
mytable->DatabaseName = "MyDB";
mytable->TableName = "MyTable";
mytable->CachedUpdates = true;
mytable->IndexedFields = "RecordNo";

try { mytable->Open (); }
catch (...) { }

if (mytable->Active) {

  mytable->Append ();
  mytable->FieldByName("firstfield")->AsString = "Hello";
  ...
  mytable->Post ();

  mytable->CommitUpdates ();
  mytable->Close ();

}

delete mytable;


Generally this cuts down the amount of disk access.  You have 64meg so there shouldn't be a problem at all.  I do this with a couple of thousand entries on a 48 meg NT box.  Disk access is what slows down DB access, especially with paradox and dbase which are based on file access rather than a dedicated database service.