Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚsqliteÖ´ÐÐʱ¼äµÄÒÉÎÊ£¿

Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ­»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£ 
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£ 

¿ÉÄÜÊÇÄÄ·½ÃæµÄÔ­Òòµ¼ÖÂÕâÑùµÄ²îÒ죿
ϵͳµÄ²»Í¬£¬sqlite°æ±¾µÄ²»Í¬»òÊDZàÒëÆ÷µÄ²»Í¬£¿

C/C++ code:

sqlite3* pHandle = 0;
int nOpenRet = sqlite3_open("/home/test.db", &pHandle);
//ouput_time();
int i = 0;
char sExec[256] = {0};
snprintf(sExec, 255, "insert into users values('user', '1');");
char* pErrMsg=0;
for (; i < 100; i++)
{
if (sqlite3_exec(pHandle,sExec, 0, 0, &pErrMsg)!= 0)
{
printf("sqlite execute fail, i=%d\n", i);
return 0;
}
}



ÒýÓÃ

Äã»úÆ÷µÄÓ²ÅÌËٶȡ£

ллÄãµÄ»Ø¸´¡£

ÎÒÅóÓѵĻúÆ÷ͬÎÒµÄÅäÖö¼Ò»Ä£Ò»Ñù£¬ËùÒÔ¿ÉÒÔÅųýÕâÀàÎÊÌâ¡£


ÒýÓÃ
ÅäÖÃÒ»ÑùµÄ»°£¬Ó¦¸Ã¸ú²Ù×÷ϵͳÒÔ¼°±àÒëÆ÷µÄ°æ±¾ÓйØϵ¡£100ÌõÊý¾Ý£¬Ó¦¸ÃÏ൱¿ìµÄ


ÎÒÔÚÆäËûÁ½Ì¨»úÆ÷ÉÏÔËÐйý,һ̨ϵͳºÍÎÒµÄÒ»Ñù¶¼ÊÇubuntu.²»¹ý±àÒëÆ÷ÓõIJ»Í¬,
ËûÊÇʹÓÃemacs.
Ö»ÊǾõµÃ±àÒëÆ÷Ôì³ÉÕâÑùµÄ²îÒìÊDz»ÊÇÓÐЩ¿äÕÅ?



ÕÒµ½Ô­ÒòÁË,ºÍϵͳµÄÎļþϵͳ¸ñʽ²îÒìÓйØ.
ÔÚext3 ºÍext4ÉϵIJ»Í¬.
лл¸÷λ»ØÌû


Ïà¹ØÎÊ´ð£º

ÔÚÏßµÈ,¹ØÓÚmysqlÓï¾äתsqliteÓï¾äµÄÎÊÌâ

SQL code:
SELECT a1.FileID AS FileID, SUM( a1.Count + a2.Count + a3.Count + a4.Count ) AS Count
from gmpTableWordList AS a1
INNER JOIN gmpTableWordList AS a2
INNER JOIN gmpTableWordList AS a3
IN ......

C# Á¬½Ó Sqlite ÊÂÎñµÄÎÊÌâ

// ´ò¿ªÊý¾Ý¿â
SQLiteConnection dconn = new System.Data.SQLite.SQLiteConnection();
dconn.ConnectionString = @"Data Source=D:\db.sdb";
dconn.Open();
SQLiteCommand dcmd = dconn.Crea ......

sqlite dinstincÎÊÌâ

ΪʲôÓÃselect name,distinct phone from phone_book¾Í˵Óï·¨´íÎó£¬
      ÓÃselect distinct phone,name from phone_book¾Í¿ÉÒÔ£¿
ûÓÐΪʲô distinct ÊÇ select µÄÐÞÊηû£¬Ö»ÄÜÔÚ select ºóÖ ......

SQLiteÖÐÎÄÂÒÂëÎÊÌâ

ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......

¹ØÓÚsqliteµÄÎÊÌâ

ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£

ÎÊÌ⣺ÈçºÎÊ¹Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ