打印本文 打印本文 关闭窗口 关闭窗口
同时开21个进程对SQL进行速度测试
作者:武汉SEO闵涛  文章来源:敏韬网  点击数3498  更新时间:2007/11/14 13:06:22  文章录入:mintao  责任编辑:mintao
nbsp;nRetCode = 1;
 }
 else
 {
  // TODO: 在此处为应用程序的行为编写代码。
  CString command, TableName;
  CString str;

  TableName = "table总";
  str = CString("E:\\OutPut\\c\\c\\Debug\\c.exe ") + TableName;

  STARTUPINFO LargeSi = {0};
  LargeSi.cb = sizeof(STARTUPINFO);
  PROCESS_INFORMATION LargePf;

  ::CreateProcess(NULL, str.GetBuffer(), NULL, NULL, FALSE, CREATE_NEW_CONSOLE, NULL, NULL, &LargeSi, &LargePf);

  for (int i=1; i<=20; i++)
  {
   temp.Format("%d", i);
   TableName = CString("table") + temp;
   str = CString("E:\\OutPut\\a\\a\\Debug\\a.exe ") + TableName;
   
   //AfxMessageBox(str);
   STARTUPINFO si = {0};
   si.cb = sizeof(STARTUPINFO);
   PROCESS_INFORMATION pf;
   
   ::CreateProcess(NULL, str.GetBuffer(), NULL, NULL, FALSE, CREATE_NEW_CONSOLE, NULL, NULL, &si, &pf);

  }
 }

 ct = CTime::GetCurrentTime();
 temp.Format("%d分%d秒", ct.GetMinute(), ct.GetSecond());
 file << "主console程序结束时间:" << temp << endl;

 return nRetCode;
}

// c.cpp : 定义控制台应用程序的入口点。
//

#include "stdafx.h"
#include "c.h"
#include "DataAccess.h"
#include <fstream>
using namespace std;

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// 唯一的应用程序对象

CWinApp theApp;

using namespace std;

int _tmain(int argc, TCHAR* argv[], TCHAR* envp[])
{
 int nRetCode = 0;
 ofstream file("test.txt",std::ios::app);
 CTime ct;
 CString text;

 ct = CTime::GetCurrentTime();
 text.Format("%d分%d秒", ct.GetMinute(), ct.GetSecond());
 file << argv[1] << "开始时间:" << text << endl;

 CoInitialize(NULL);

 // 初始化 MFC 并在失败时显示错误
 if (!AfxWinInit(::GetModuleHandle(NULL), NULL, ::GetCommandLine(), 0))
 {
  // TODO: 更改错误代码以符合您的需要
  _tprintf(_T("致命错误: MFC 初始化失败\n"));
  nRetCode = 1;
 }
 else
 {
  // TODO: 在此处为应用程序的行为编写代码。
  CAdoConnection AdoConnection;
  CAdoCommand AdoCommand;
  AdoConnection.ConnectingString = "Provider=SQLOLEDB;Network Address=127.0.0.1;Initial Catalog=临时数据库";
  AdoConnection.UserName = "sa";
  AdoConnection.PassWord = "sa";
  if (AdoConnection.Connected == FALSE)
   AdoConnection.Connected = TRUE;
  
  AdoCommand.CommandType = adCmdText;
  AdoCommand.CommandText = string("INSERT INTO ") + string(argv[1]) + string(" (name) VALUES (''''ghb'''')");
  AdoCommand.m_AdoConnection = &AdoConnection;

  for (int i = 0; i<200000; i++)
   AdoCommand.Execute();

  AdoConnection.Connected = FALSE;

 }
 CoUninitialize();

 ct = CTime::GetCurrentTime();
 text.Format("%d分%d秒", ct.GetMinute(), ct.GetSecond());
 file << argv[1] << "结束时间:" << text << endl;


 return nRetCode;
}

上一页  [1] [2] [3] 

打印本文 打印本文 关闭窗口 关闭窗口