請問各位, 我寫了一個window service程式,用socket收到data存到buffer(vector),然後用thread寫到db中. 但大量資料(約10000筆)時,CPU使用率逹60%以上,寫入動作緩慢,但不會使程式死掉. 請各位指導,解決CPU使用率過高 和 資料處理緩慢 問題    以下為我片斷程式.  

主程式 --- 收data
void __fastcall TService1::ServiceExecute(TService *Sender)
{
  ClientSocket1->Active = true;
  try
  {
    ADOConnection1->ConnectionString = ConnectStr;
    ADOConnection1->Connected = true;
    GTable->Active = true;
    BTable->Active = true;
    GRecallTable->Active = true;
    BRecallTable->Active = true;
  }
  catch(...)
  {
    ConnectTimer->Enabled = true;
    MsgWriteFile("Database open error.");
  }      while(!Terminated)
  {
    ServiceThread->ProcessRequests(true);
    Sleep(10);
  }
}
//---------------------------------------------------------------------------
void __fastcall TService1::ClientSocket1Error(TObject *Sender,
      TCustomWinSocket *Socket, TErrorEvent ErrorEvent, int &ErrorCode)
{
   //.......
   GBuffer.push_back(GS);
   BBuffer.push_back(BS);
}
//---------------------------------------------------------------------------
void __fastcall TService1::GTableAfterPost(TDataSet *DataSet)
{
  GTable->Refresh();
}
//---------------------------------------------------------------------------
void __fastcall TService1::BTableAfterPost(TDataSet *DataSet)
{
  BTable->Refresh();
}
//---------------------------------------------------------------------------
void __fastcall TService1::GRecallTableAfterPost(TDataSet *DataSet)
{
  GRecallTable->Refresh();
}
//---------------------------------------------------------------------------
void __fastcall TService1::BRecallTableAfterPost(TDataSet *DataSet)
{
  BRecallTable->Refresh();
}
//---------------------------------------------------------------------------
Thread --- data寫到db
void __fastcall DBthread::Execute()
{
  //---- Place thread code here ----
  while(!Terminated)
  {
    Synchronize(WriteDB);
    Sleep(10);
  }
}
//---------------------------------------------------------------------------
void __fastcall DBthread::WriteDB()
{
  if(!ADOConnection1->Connected) return;
  
  if(GBuffer.size() > 0)
  {
    TGType Ptr;
    vector::iterator Ptrs = GBuffer.begin();
    memmove(&Ptr,Ptrs,sizeof(TGType));
    GBuffer.erase(Ptrs);        try
    {
      GPSTable->Insert();
      //***data寫到各field
      GPSTable->Post();
    }
    catch(...)
    {
      if(GTable->State == dsInsert) GTable->Cancel();
    }
  }      if(BBuffer.size() > 0)
  {
    TBType Ptr;
    vector::iterator Ptrs = BBuffer.begin();
    memmove(&Ptr,Ptrs,sizeof(TBType));
    BBuffer.erase(Ptrs);        try
    {
      BarTable->Insert();
      //***data填到field
      BarTable->Post();
    }
    catch(...)
    {
      if(BarTable->State == dsInsert) BarTable->Cancel();
    }
  }
}
//---------------------------------------------------------------------------