🚀 go-pugleaf

I am adding 100,000 rows to an initialized MySQL database using the code 
below.  The application gets much slower as the number of records grows. 
This is an obvious result of the database itself having more work to do with 
indexes, etc. but is there also something that I can do on the application 
side to speed things up ?   I am wondering if the ClientDataSet, Provider, 
etc. are also getting big and have more work to do.  If so, what is the best 
way to avoid this ?

Thank you.
Curt

I am using the following code to add the records:

ADOConnection1->Open();
DM->ClientDataSet1->Open();

for (int i = 0; i < equities; i++) {
  for (int j = 0; j < days; j++) {
    DM->ClientDataSet1->Insert();
    ...   // table fields are loaded here
    DM->ClientDataSet1->Post();
   }
  }
  if (i%10 == 0) {  // apply updates after 2000 rows are cached
   DM->ClientDataSet1->ApplyUpdates(0);
  }
}
DM->ClientDataSet1->ApplyUpdates(0);
DM->ADOConnection1->Close();