C#和C++的速度大比拼（第二部分）

编译:藏北

CREATE TABLE testtable
(
  col1 INTEGER,
  col2 VARCHAR(50),

  PRIMARY KEY (col1)
)      

代码五：db.cpp
#import "msado15.dll" no_namespace rename("EOF", "EndOfFile")
#include <iostream>
#include <string>
#include <sstream>

int main(int argc, char* argv[])
{
  if (argc != 2)
  {
    std::cerr << "Usage:\tdb [rows]\n"; 
    return 1;
  };

  ::CoInitialize(NULL);
  int NUM = atoi(argv[1]);
  DWORD dw = ::GetTickCount();
  _ConnectionPtr conptr(__uuidof(Connection));
  conptr->Open(L"Provider=Microsoft.Jet.OLEDB.4.0;"
    "Data Source=c:\\db.mdb;",
    L"",
    L"",
    adOpenUnspecified);
  for (int i=0;iExecute(sql, &RecordsEffected, adCmdText);
  };

  DWORD dw2 = ::GetTickCount();
  std::cout << "Milliseconds = " << dw2-dw 
    << std::endl;  
  dw = ::GetTickCount();
  for (int j=0;j<100;j++)
  {
    _RecordsetPtr rsptr(__uuidof(Recordset));
    rsptr->Open(L"SELECT col1, col2 FROM testtable",
    conptr.GetInterfacePtr(),  
    adOpenForwardOnly, adLockOptimistic, adCmdText);
    while (rsptr->EndOfFile)
    {
      _variant_t v1 = rsptr->GetCollect("col1");
      _variant_t v2 = rsptr->GetCollect("col2");
      rsptr->MoveNext();
    };
    rsptr->Close();
  };

  dw2 = ::GetTickCount();
  std::cout << "Milliseconds = " << dw2-dw 
    << std::endl;  
  dw = ::GetTickCount();
  for (int i=0;i

下表为运行十次，每次100行记录的结果
         
表三：数据库测试结果

      

序号

C++(～毫秒) 

C#(～毫秒)

代码七：xml.cpp
#import <msxml3.dll> named_guids
#include <iostream>
int main(int argc, char* argv[])
{
  if (argc != 2)
  {
    std::cerr << "Usage:\txml [filename]\n"; 
    return 1;
  };

  ::CoInitialize(NULL);
  DWORD dw = ::GetTickCount();
  for (int i=0;i<100;i++)
  {
    MSXML2::IXMLDOMDocumentPtr DomDocument(
      MSXML2::CLSID_DOMDocument) ;
    _bstr_t filename = argv[1];
    DomDocument->async = false;
    DomDocument->load(filename);
  }

  DWORD dw2 = ::GetTickCount();
  std::cout << "Milliseconds = " << dw2-dw 
    << std::endl;
  ::CoUninitialize();
  return 0;
}
      

代码七：xml.cs
using System;
using System.Xml;

namespace xml2
{
  class Class1
  {
    static void Main(string[] args)
    {  
      if (args.Length != 1)
      {
        Console.WriteLine("Usage:\txml [filename]");
        return;
      }

      long dt = DateTime.Now.Ticks;      
      for (int i=0;i<100;i++)
      {
        XmlDocument doc = new XmlDocument();
        doc.Load(args[0]);
      }

      long dt2 = DateTime.Now.Ticks;
      System.Console.WriteLine("Milliseconds = {0}", (dt2-dt)/10000);
    }
  }
}