sl@0: /*
sl@0: * Copyright (c) 2008-2009 Nokia Corporation and/or its subsidiary(-ies).
sl@0: * All rights reserved.
sl@0: * This component and the accompanying materials are made available
sl@0: * under the terms of "Eclipse Public License v1.0"
sl@0: * which accompanies this distribution, and is available
sl@0: * at the URL "http://www.eclipse.org/legal/epl-v10.html".
sl@0: *
sl@0: * Initial Contributors:
sl@0: * Nokia Corporation - initial contribution.
sl@0: *
sl@0: * Contributors:
sl@0: *
sl@0: * Description:
sl@0: *
sl@0: */
sl@0: 
sl@0: 
sl@0: 
sl@0: #include <stdio.h>
sl@0: #include <stdlib.h>
sl@0: #include <string.h>
sl@0: #include <wchar.h>
sl@0: #include <errno.h>
sl@0: #include <sys/stat.h>
sl@0: #include <unistd.h>
sl@0: #include <sqlite3.h>
sl@0: #include "t_sqliteperf.h"
sl@0: 
sl@0: static sqlite3* TheDb2 = 0;
sl@0: 
sl@0: static char TheSqlBuf2[2000];
sl@0: 
sl@0: #define UNUSED_VAR(a) (a) = (a)
sl@0: 
sl@0: /* ///////////////////////////////////////////////////////////////////////////////////// */
sl@0: 
sl@0: static void TestCleanup()
sl@0: 	{
sl@0: 	if(TheDb2)
sl@0: 		{
sl@0: 		sqlite3_close(TheDb2);
sl@0: 		TheDb2 = 0;
sl@0: 		}
sl@0: 	(void)remove(TestDbName());
sl@0: 	}
sl@0: 
sl@0: /* ///////////////////////////////////////////////////////////////////////////////////// */
sl@0: /* Test macros and functions */
sl@0: 
sl@0: static void Check1(int aValue, int aLine)
sl@0: 	{
sl@0: 	if(!aValue)
sl@0: 		{
sl@0: 		if(TheDb2)
sl@0: 			{
sl@0: 			const char* errmsg = sqlite3_errmsg(TheDb2);
sl@0: 			PrintS("*** SQLITE error message: %s\r\n", errmsg);
sl@0: 			}
sl@0: 		TestCleanup();
sl@0: 		PrintI("*** Test check failed! Line=%d\r\n", aLine);
sl@0: 		TestAbort(aLine);
sl@0: 		}
sl@0: 	}
sl@0: static void Check2(int aValue, int aExpected, int aLine)
sl@0: 	{
sl@0: 	if(aValue != aExpected)
sl@0: 		{
sl@0: 		if(TheDb2)
sl@0: 			{
sl@0: 			const char* errmsg = sqlite3_errmsg(TheDb2);
sl@0: 			PrintS("*** SQLITE error message: %s\r\n", errmsg);
sl@0: 			}
sl@0: 		TestCleanup();
sl@0: 		PrintIII("*** Test check failed! Line=%d. Expected error: %d, got: %d\r\n", aLine, aExpected, aValue);
sl@0: 		TestAbort(aLine);
sl@0: 		}
sl@0: 	}
sl@0: #define TEST(arg) Check1((arg), __LINE__)
sl@0: #define TEST2(aValue, aExpected) Check2(aValue, aExpected, __LINE__)
sl@0: 
sl@0: /* ///////////////////////////////////////////////////////////////////////////////////// */
sl@0: 
sl@0: //"PRAGMA cache_size=1024" and "PRAGMA locking_mode=EXCLUSIVE" statements executed only if 
sl@0: //aPerfTestMode is EPerfTestSqliteMode (to match the Symbian SQL build time settings of SQLite)
sl@0: static void ExecSqliteConfig(TPerfTestMode aPerfTestMode)
sl@0: 	{
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	if(aPerfTestMode == EPerfTestSqliteSqlMode)
sl@0: 		{
sl@0: 		int err;
sl@0: 		err = sqlite3_exec(TheDb2, "PRAGMA cache_size=1024", 0, 0, 0);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		err = sqlite3_exec(TheDb2, "PRAGMA locking_mode=EXCLUSIVE", 0, 0, 0);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		err = sqlite3_exec(TheDb2, "PRAGMA auto_vacuum=incremental", 0, 0, 0);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		err = sqlite3_exec(TheDb2, "PRAGMA journal_mode=PERSIST", 0, 0, 0);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		err = sqlite3_exec(TheDb2, "PRAGMA journal_size_limit=2048000", 0, 0, 0);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		}
sl@0: 	}
sl@0: 
sl@0: /* ///////////////////////////////////////////////////////////////////////////////////// */
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4018
sl@0: @SYMTestCaseDesc		SQLite library multi-insert performance test.
sl@0: 						The test inserts 1000 records in a single transaction and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4010 test case - "SQL server multi-insert performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library multi-insert performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteMultiInsertTest(TPerfTestMode aPerfTestMode, const char aInsertSql[], int aInsertRecCnt)
sl@0: 	{
sl@0: 	int err;
sl@0: 	int i;
sl@0: 	const char* tail = 0;
sl@0: 	sqlite3_stmt* stmt = 0;
sl@0: 	unsigned int fc;
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	err = sqlite3_prepare(TheDb2, aInsertSql, -1, &stmt, &tail);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	fc = FastCounterValue();
sl@0: 	err = sqlite3_exec(TheDb2, "BEGIN", 0, 0, 0);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 
sl@0: 	for(i=0;i<aInsertRecCnt;++i)
sl@0: 		{
sl@0: 		err = sqlite3_bind_int(stmt, 1, i + 1);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 
sl@0: 		err = sqlite3_step(stmt);
sl@0: 		TEST2(err, SQLITE_DONE);
sl@0: 		
sl@0: 		err = sqlite3_reset(stmt);		
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		}
sl@0: 
sl@0: 	err = sqlite3_exec(TheDb2, "COMMIT", 0, 0, 0);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestMultiInsert, FastCounterValue() - fc);
sl@0: 
sl@0: 	sqlite3_finalize(stmt);	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: static void FormatSqlStmt(char* aSqlBuf, const char aSql[], int aRecIds[], int aRecCnt)
sl@0: 	{
sl@0: 	int i;
sl@0: 	strcpy(aSqlBuf, aSql);
sl@0: 	strcat(aSqlBuf, "(");
sl@0: 	for(i=0;i<aRecCnt;++i)
sl@0: 		{
sl@0: 		char tmp[10];
sl@0: 		sprintf(tmp, "%d", aRecIds[i]);
sl@0: 		strcat(aSqlBuf, tmp);
sl@0: 		strcat(aSqlBuf, ",");
sl@0: 		}
sl@0: 	aSqlBuf[strlen(aSqlBuf) - 1] = ')';
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4019
sl@0: @SYMTestCaseDesc		SQLite library multi-update performance test.
sl@0: 						The test updates 100 records and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The IDs of the updated records are exactly the same as the IDs of the updated
sl@0: 						records, used by SYSLIB-SQLITE3-UT-4011 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4011 test case - "SQL server multi-update performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library multi-update performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteMultiUpdateTest(TPerfTestMode aPerfTestMode, const char aUpdateSql[], int aUpdateRecIds[], int aUpdateRecCnt)
sl@0: 	{
sl@0: 	int err;
sl@0: 	unsigned int fc;
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	FormatSqlStmt(TheSqlBuf2, aUpdateSql, aUpdateRecIds, aUpdateRecCnt);
sl@0: 
sl@0: 	fc = FastCounterValue();
sl@0: 	err = sqlite3_exec(TheDb2, TheSqlBuf2, 0, 0, 0);
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestMultiUpdate, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4020
sl@0: @SYMTestCaseDesc		SQLite library multi-delete performance test.
sl@0: 						The test deletes 100 records and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The IDs of the deleted records are exactly the same as the IDs of the deleted
sl@0: 						records, used by SYSLIB-SQLITE3-UT-4012 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4012 test case - "SQL server multi-delete performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library multi-delete performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteMultiDeleteTest(TPerfTestMode aPerfTestMode, const char aDeleteSql[], int aDeleteRecIds[], int aDeleteRecCnt)
sl@0: 	{
sl@0: 	int err;
sl@0: 	unsigned int fc;
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	FormatSqlStmt(TheSqlBuf2, aDeleteSql, aDeleteRecIds, aDeleteRecCnt);
sl@0: 
sl@0: 	fc = FastCounterValue();
sl@0: 	err = sqlite3_exec(TheDb2, TheSqlBuf2, 0, 0, 0);
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestMultiDelete, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4021
sl@0: @SYMTestCaseDesc		SQLite library multi-select performance test.
sl@0: 						The test selects 100 records and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The IDs of the selected records are exactly the same as the IDs of the selected
sl@0: 						records, used by SYSLIB-SQLITE3-UT-4013 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4013 test case - "SQL server multi-select performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library multi-select performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteMultiSelectTest(TPerfTestMode aPerfTestMode, const char aSelectSql[], int aSelectRecIds[], int aSelectRecCnt)
sl@0: 	{
sl@0: 	int err;
sl@0: 	const char* tail = 0;
sl@0: 	sqlite3_stmt* stmt = 0;
sl@0: 	int recCnt = 0;
sl@0: 	unsigned int fc;
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	FormatSqlStmt(TheSqlBuf2, aSelectSql, aSelectRecIds, aSelectRecCnt);
sl@0: 
sl@0: 	err = sqlite3_prepare(TheDb2, TheSqlBuf2, -1, &stmt, &tail);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	fc = FastCounterValue();
sl@0: 	while((err = sqlite3_step(stmt)) == SQLITE_ROW)
sl@0: 		{
sl@0: 		__int64 i64;
sl@0: 		double d;
sl@0: 		const unsigned short* t;
sl@0: 		const unsigned char* b;
sl@0: 		
sl@0: 		i64 = sqlite3_column_int64(stmt, 0);
sl@0: 		UNUSED_VAR(i64);
sl@0: 		d = sqlite3_column_double(stmt, 1);
sl@0: 		UNUSED_VAR(d);
sl@0: 		t = (const unsigned short*)sqlite3_column_text16(stmt, 2);
sl@0: 		UNUSED_VAR(t);
sl@0: 		b = (const unsigned char*)sqlite3_column_blob(stmt, 3);
sl@0: 		UNUSED_VAR(b);
sl@0: 		++recCnt;
sl@0: 		}
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestMultiSelect, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_DONE);
sl@0: 	TEST2(recCnt, aSelectRecCnt);
sl@0: 
sl@0: 	sqlite3_finalize(stmt);	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4022
sl@0: @SYMTestCaseDesc		SQLite library single-insert performance test.
sl@0: 						The test inserts one record and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The ID of the inserted record is exactly the same as the ID of the inserted
sl@0: 						record, used by SYSLIB-SQLITE3-UT-4014 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4014 test case - "SQL server single-insert performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library single-insert performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteSingleInsertTest(TPerfTestMode aPerfTestMode, const char aSingleInsertSql[], TInt aInsertRecId)
sl@0: 	{
sl@0: 	int err;
sl@0: 	unsigned int fc;
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	sprintf(TheSqlBuf2, aSingleInsertSql, aInsertRecId);
sl@0: 	fc = FastCounterValue();
sl@0: 	err = sqlite3_exec(TheDb2, TheSqlBuf2, 0, 0, 0);
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestSingleInsert, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4023
sl@0: @SYMTestCaseDesc		SQLite library single-update performance test.
sl@0: 						The test updates one record and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The ID of the updated record is exactly the same as the ID of the updated
sl@0: 						record, used by SYSLIB-SQLITE3-UT-4015 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4015 test case - "SQL server single-update performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library single-update performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteSingleUpdateTest(TPerfTestMode aPerfTestMode, const char aSingleUpdateSql[], TInt aUpdateRecId)
sl@0: 	{
sl@0: 	int err;
sl@0: 	unsigned int fc;
sl@0: 	char tmp[10];
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	sprintf(tmp, "%d", aUpdateRecId);
sl@0: 	strcpy(TheSqlBuf2, aSingleUpdateSql);
sl@0: 	strcat(TheSqlBuf2, tmp);
sl@0: 	fc = FastCounterValue();
sl@0: 	err = sqlite3_exec(TheDb2, TheSqlBuf2, 0, 0, 0);
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestSingleUpdate, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4024
sl@0: @SYMTestCaseDesc		SQLite library single-delete performance test.
sl@0: 						The test deletes one record and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The ID of the deleted record is exactly the same as the ID of the deleted
sl@0: 						record, used by SYSLIB-SQLITE3-UT-4016 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4016 test case - "SQL server single-delete performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library single-delete performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteSingleDeleteTest(TPerfTestMode aPerfTestMode, const char aSingleDeleteSql[], TInt aDeleteRecId)
sl@0: 	{
sl@0: 	int err;
sl@0: 	unsigned int fc;
sl@0: 	char tmp[10];
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	sprintf(tmp, "%d", aDeleteRecId);
sl@0: 	strcpy(TheSqlBuf2, aSingleDeleteSql);
sl@0: 	strcat(TheSqlBuf2, tmp);
sl@0: 	fc = FastCounterValue();
sl@0: 	err = sqlite3_exec(TheDb2, TheSqlBuf2, 0, 0, 0);
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestSingleDelete, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQLITE3-UT-4025
sl@0: @SYMTestCaseDesc		SQLite library single-select performance test.
sl@0: 						The test selects one record and stores 
sl@0: 						the execution time for later use (comparison and printing).
sl@0: 						The ID of the selected record is exactly the same as the ID of the selected
sl@0: 						record, used by SYSLIB-SQLITE3-UT-4017 test case.
sl@0: 						The results of this test case will be compared against the results of
sl@0: 						the SYSLIB-SQLITE3-UT-4017 test case - "SQL server single-select performance test".
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQLite library single-select performance test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ8782
sl@0: */
sl@0: void SqliteSingleSelectTest(TPerfTestMode aPerfTestMode, const char aSingleSelectSql[], TInt aSelectRecId)
sl@0: 	{
sl@0: 	int err;
sl@0: 	const char* tail = 0;
sl@0: 	sqlite3_stmt* stmt = 0;
sl@0: 	int recCnt = 0;
sl@0: 	unsigned int fc;
sl@0: 	char tmp[10];
sl@0: 	
sl@0: 	TEST(aPerfTestMode > EPerfTestSqlMode && aPerfTestMode < EPerfTestModeCnt);
sl@0: 	TEST(!TheDb2);
sl@0: 	err = sqlite3_open(TestDbName(), &TheDb2);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	ExecSqliteConfig(aPerfTestMode);
sl@0: 
sl@0: 	sprintf(tmp, "%d", aSelectRecId);
sl@0: 	strcpy(TheSqlBuf2, aSingleSelectSql);
sl@0: 	strcat(TheSqlBuf2, tmp);
sl@0: 	
sl@0: 	err = sqlite3_prepare(TheDb2, TheSqlBuf2, -1, &stmt, &tail);
sl@0: 	TEST2(err, SQLITE_OK);
sl@0: 	
sl@0: 	fc = FastCounterValue();
sl@0: 	while((err = sqlite3_step(stmt)) == SQLITE_ROW)
sl@0: 		{
sl@0: 		__int64 i64;
sl@0: 		double d;
sl@0: 		const unsigned short* t;
sl@0: 		const unsigned char* b;
sl@0: 		
sl@0: 		i64 = sqlite3_column_int64(stmt, 0);
sl@0: 		UNUSED_VAR(i64);
sl@0: 		d = sqlite3_column_double(stmt, 1);
sl@0: 		UNUSED_VAR(d);
sl@0: 		t = (const unsigned short*)sqlite3_column_text16(stmt, 2);
sl@0: 		UNUSED_VAR(t);
sl@0: 		b = (const unsigned char*)sqlite3_column_blob(stmt, 3);
sl@0: 		UNUSED_VAR(b);
sl@0: 		++recCnt;
sl@0: 		}
sl@0: 	StorePerfTestResult(aPerfTestMode, EPerfTestSingleSelect, FastCounterValue() - fc);
sl@0: 	TEST2(err, SQLITE_DONE);
sl@0: 	TEST2(recCnt, 1);
sl@0: 
sl@0: 	sqlite3_finalize(stmt);	
sl@0: 	sqlite3_close(TheDb2);
sl@0: 	TheDb2 = 0;
sl@0: 	}
sl@0: 
sl@0: void SqliteInitialize(TPerfTestMode aMode)
sl@0: 	{
sl@0: 	if(aMode == EPerfTestSqliteSqlMode)
sl@0: 		{
sl@0: 		const TInt KSqliteLookAsideCellSize = 128;
sl@0: 		const TInt KSqliteLookAsideCellCount = 512;
sl@0: 		int err;
sl@0: 		err = sqlite3_config(SQLITE_CONFIG_LOOKASIDE, KSqliteLookAsideCellSize, KSqliteLookAsideCellCount);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		sqlite3_soft_heap_limit(1024 * 1024);
sl@0: 		err = sqlite3_enable_shared_cache(1);
sl@0: 		TEST2(err, SQLITE_OK);
sl@0: 		}
sl@0: 	}
sl@0: 
sl@0: void SqliteFinalize(TPerfTestMode aMode)
sl@0: 	{
sl@0: 	if(aMode == EPerfTestSqliteSqlMode)
sl@0: 		{
sl@0: 		(void)sqlite3_enable_shared_cache(0);
sl@0: 		sqlite3_soft_heap_limit(0);
sl@0: 		}
sl@0: 	sqlite3_shutdown();
sl@0: 	}