[질문] Berkeley DB의 sync() 또는 close() 관련하여 100만건 이상 데이터 처리를 해보신분 계신가요?

#include "db_cxx.h"
#include <string>
 
using namespace std;
 
//----------------------------------------------------------------------------------------
//TIMER
//----------------------------------------------------------------------------------------
//#define CHECK_TIME_START  __int64 freq, start, end; if (QueryPerformanceFrequency((_LARGE_INTEGER*)&freq))  {QueryPerformanceCounter((_LARGE_INTEGER*)&start); 
//#define CHECK_TIME_END(a,b) QueryPerformanceCounter((_LARGE_INTEGER*)&end);  a=(float)((double)(end - start)/freq*1000); b=TRUE;	}else{ b=FALSE;	}
//LARGE_INTEGER g_ticksPerSecond;
//LARGE_INTEGER g_t_start, g_t_end, g_t_diff;
 
 
#include <windows.h>
//http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=1040101&docId=68235573&qb=dmMg7KCV67CA7Iuc6rCE&enc=utf8&section=kin&rank=1&sort=0&spq=0&pid=f1kLqg331zZssv2GafGssv--017557&sid=S1bM8ELGVksAAHS0DGA
double			timeSecond;
LARGE_INTEGER	ticksPerSecond;
LARGE_INTEGER	t_start, t_end, t_diff;  
 
void Fn_start_timer()
{
	QueryPerformanceCounter(&t_start);
}
 
double Fn_end_timer()
{
	QueryPerformanceCounter(&t_end);
	QueryPerformanceFrequency(&ticksPerSecond);
 
	t_diff.QuadPart = t_end.QuadPart- t_start.QuadPart;
	timeSecond = (double)(double)t_diff.QuadPart/(double)ticksPerSecond.QuadPart;
 
	printf ("Elapsed CPU time:   %3.12f  sec / ticks: %I64Ld\n", timeSecond, t_diff.QuadPart);
	return timeSecond;
}
 
 
//env.BeginTxn(&txn);
//db.Get(&txn, &key, &data, flag);
//db.Put(&txn, &key, &data, flag);
//db.Erase(&txn, &key, flag);
//txn.Commit();
 
Db db_(NULL, 0);
 
void Open(bool isSecondary)
{
	char dbName[]="test.db";
	db_.open(NULL, dbName, NULL, DB_BTREE, DB_CREATE, 0);
}
 
void Close()
{
	db_.close(0);
}
 
void put()
{
	int nKey	= 1;
	int nValue	= 100;
 
	Dbt key	(&nKey,		sizeof(int));
	Dbt data(&nValue,	sizeof(int));
	db_.put	(NULL, &key, &data, 0);
}
 
void get()
{
	int nKey	= 1;
	Dbt key(&nKey, sizeof(int));
 
	int nValue	= 0;
	Dbt data;
	data.set_data(&nValue);
	data.set_ulen(sizeof(int));
	data.set_flags(DB_DBT_USERMEM);
 
	db_.get(NULL, &key, &data, 0);
//s	printf("%d\n",nValue);
}
 
void main()
{
	Open(false);
//	put();
//	get();
 
	const int max_count = 100000;
	{{
		printf("DB PUT : START\n");
		Fn_start_timer();
		for(int i=0; i<max_count; i++)
		{
			int	 nKey			= i;
			char caValue[100]	= "value!";
			Dbt key	(&nKey,		sizeof(nKey));
			Dbt data(&caValue,	sizeof(caValue));
			db_.put	(NULL, &key, &data, 0);
		}
		Fn_end_timer();
		printf("DB PUT : END\n\n");
	}}
 
	{{
		printf("DB GET : START\n");
		Fn_start_timer();
		for(int i=0; i<max_count; i++)
		{
			int	 nKey			= i;
			char caValue[100]	= {'\0',};
 
			Dbt key	(&nKey,		sizeof(nKey));
 
			Dbt data;
			data.set_data(&caValue);
			data.set_ulen(sizeof(caValue));
			data.set_flags(DB_DBT_USERMEM);
 
			db_.get(NULL, &key, &data, 0);
		//s	printf("%s\n",caValue);
		}
		Fn_end_timer();
		printf("DB GET : END\n\n");
	}}
 
	{{
		printf("DB DELETE : START\n");
		Fn_start_timer();
		for(int i=0; i<max_count; i++)
		{
			int	 nKey			= i;
			Dbt key	(&nKey,		sizeof(nKey));
			db_.del(NULL, &key, 0);
		//	get		(DbTxn *txnid, Dbt *key, Dbt *data, u_int32_t flags);
		//	del		(DbTxn *txnid, Dbt *key, u_int32_t flags);
		//	open	(DbTxn *txnid, const char *, const char *subname, DBTYPE, u_int32_t, int);
		//	remove	(const char *, const char *, u_int32_t);
		}
		Fn_end_timer();
		printf("DB DELETE : END\n\n");
	}}
	Close();
}