TMSTable->Delete() is very slow

sct_alan · Post by **sct_alan** » Tue 23 Jun 2009 18:28

TMSTable->Delete() is very slow.
Is there a faster way to delete rows?
This is what I’m currently doing (All rows in table are deleted) in C++.

if(!dmSCT->MSTable_Delete->Eof)
{
do
{
dmSCT->MSTable_Delete->Delete() ;
}while(!dmSCT->MSTable_Delete->Eof) ;
}

Alan

Dimon · Post by **Dimon** » Wed 24 Jun 2009 06:44

To delete all rows from a table you can use the "TRUNCATE TABLE" SQL statement, like this:

Code: Select all

  MSQuery.SQL.Text := 'TRUNCATE TABLE tablename';
  MSQuery.Execute;