Firebird测试文档
测试程序1：创建数据库并插入20万条数据，共有11字段，执行时间125秒
#include <unistd.h>
#include <iostream>
#define IBPP_LINUX
#include "ibpp.h"
#include "all_in_one.cpp"
#include <time.h>
#include <string>
using namespace std;mysql文档手机版
const char* g_szDBName="/dbs/a.fdb";
const char* g_szServerName="";
const char* g_szUserName="SYSDBA";
const char* g_szPassword="masterkey";
string long2str(long num)
{
string str1 ="";
while(num)
{
str1=(char)(num%10+48)+str1;
num/=10;
}
return str1;
}
int main()
{
        time_t stime,etime;
        IBPP::Database db = IBPP::DatabaseFactory(g_szServerName,g_szDBName,g_szUserName,g_szPassword);
        db->Create(3);
        db->Connect();
        cout<<"insert 200000 items:"<<endl;
stime=time(NULL);
IBPP::Transaction tr =IBPP::TransactionFactory(db);
tr->Start();
try
{
IBPP::Statement st = IBPP::StatementFactory(db,tr);
st->Execute("create table testtable(ID varchar(20) not null primary key,name varchar(10) not null,age varchar(10),username1 varchar(20),password1 varchar(20), username2 varchar(20),password2 varchar(20), username3 varchar(20),password3 varchar(20), username4    varchar(20),password4  varchar(20)”);
tr->CommitRetain();
for(long i=1;i<200000;i++)
{
string str = "insert into testtable(id,name,age,username1,password1,username2,password2,username3,password3,username4,password4) values('";
str.append(long2str(i));
str.append("','zhangsan','23','lisi','lisi','lisi','lisi','lisi','lisi','lisi','lisi')");
st->Execute(str);
tr->CommitRetain();
}
tr->Commit();
}
catch(IBPP::SQLException &e)
{
cerr<<e.what()<<endl;
tr->Rollback();
}
etime=time(NULL);
cout<<"the end"<<endl;
cout<<"time:"<<etime-stime<<" s"<<endl;
        return 0;
}
测试程序2：插入80万条数据，共有11字段，执行时间561秒
#include <unistd.h>
#include <iostream>
#define IBPP_LINUX
#include "ibpp.h"
#include "all_in_one.cpp"
#include <time.h>
#include <string>
using namespace std;
const char* g_szDBName="/dbs/a.fdb";
const char* g_szServerName="";
const char* g_szUserName="SYSDBA";
const char* g_szPassword="masterkey";
string long2str(long num)
{
string str1 ="";
while(num)
{
str1=(char)(num%10+48)+str1;
num/=10;
}
return str1;
}
int main()
{
        time_t stime,etime;
        IBPP::Database db = IBPP::DatabaseFactory(g_szServerName,g_szDBName,g_szUserName,g_szPassword);
        db->Create(3);
        db->Connect();
        cout<<"insert 800000 items:"<<endl;
stime=time(NULL);
IBPP::Transaction tr =IBPP::TransactionFactory(db);
tr->Start();
try
{
IBPP::Statement st = IBPP::StatementFactory(db,tr);
st->Execute("create table testtable(ID varchar(20) not null primary key,name varchar(10) not null,age varchar(10),username1 varchar(20),pass word1 varchar(20), username2 varchar(20),password2 varchar(20), username3 varchar(20),password3 varchar(20), username4    varchar(20),password4  varchar(20)”);
tr->CommitRetain();
for(long i=1;i<800000;i++)
{
string str = "insert into testtable(id,name,age,username1,password1,username2,password2,username3,password3,username4,password4) values('";
str.append(long2str(i));
str.append("','zhangsan','23','lisi','lisi','lisi','lisi','lisi','lisi','lisi','lisi')");
st->Execute(str);
tr->CommitRetain();
}
tr->Commit();
}
catch(IBPP::SQLException &e)
{
cerr<<e.what()<<endl;
tr->Rollback();
}
etime=time(NULL);
cout<<"the end"<<endl;
cout<<"time:"<<etime-stime<<" s"<<endl;
        return 0;
}
测试程序3：修改1000000条数据 ， 共有11字段， 执行时间18秒
#include <unistd.h>
#include <iostream>
#define IBPP_LINUX
#include "ibpp.h"
#include "all_in_one.cpp"
#include <time.h>
#include <string>
       
using namespace std;
       
const char* g_szDBName="/dbs/a.fdb";
const char* g_szServerName="";
const char* g_szUserName="SYSDBA";
const char* g_szPassword="masterkey";
string long2str(long num)
{
string str1 ="";
while(num)
{
str1=(char)(num%10+48)+str1;
num/=10;
}
return str1;
}
int main()
{
        time_t stime,etime;
        IBPP::Database db = IBPP::DatabaseFactory(g_szServerName,g_szDBName,g_szUserName,g_szPassword);
        db->Connect();
        cout<<"update 1000000 items:"<<endl;
stime=time(NULL);
IBPP::Transaction tr =IBPP::TransactionFactory(db);
tr->Start();
try   
{
IBPP::Statement st = IBPP::StatementFactory(db,tr);
st->Execute("update testtable set username1='wangwu',password1='wangwu'");
tr->CommitRetain();
tr->Commit();
}
catch(IBPP::SQLException &e)
{
cerr<<e.what()<<endl;
tr->Rollback();
}
etime=time(NULL);
cout<<"the end"<<endl;
cout<<"time:"<<etime-stime<<" s"<<endl;
return 0;
}
测试程序4：查询10万次，执行时间 54秒
#include <unistd.h>
#include <iostream>

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。