SQLITEËÙ¶ÈÆÀ²â

SQLite ×÷Ϊһ¸öÇáÁ¿¼¶Ç¶ÈëʽÊý¾Ý¿â£¬»¹ÊǷdz£ºÃÓõġ£ÓêºÛ¼«Á¦ÍƼö~~~~~~ 
½ñÌìÓиöÅóÓѲâÊÔ SQLite£¬È»ºóµÃ³öµÄ½áÂÛÊÇ£ºSQLite ЧÂÊÌ«µÍ£¬ÅúÁ¿²åÈë1000Ìõ¼Ç¼£¬¾ÓÈ»ºÄʱ 2 ·ÖÖÓ£¡
ÏÂÃæÊÇËû·¢¸øÎҵIJâÊÔ´úÂë¡£ÎÒÔÎ~~~~~~ 
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
// ´´½¨Êý¾Ý¿âÎļþ
File.Delete("test1.db3");
SQLiteConnection.CreateFile("test1.db3");
DbProviderFactory factory = SQLiteFactory.Instance;
using (DbConnection conn = factory.CreateConnection())
{
  // Á¬½ÓÊý¾Ý¿â
  conn.ConnectionString = "Data Source=test1.db3";
  conn.Open();
  // ´´½¨Êý¾Ý±í
  string sql = "create table [test1] ([id] INTEGER PRIMARY KEY, [s] TEXT COLLATE NOCASE)";
  DbCommand cmd = conn.CreateCommand();
  cmd.Connection = conn;
  cmd.CommandText = sql;
  cmd.ExecuteNonQuery();
  // Ìí¼Ó²ÎÊý
  cmd.Parameters.Add(cmd.CreateParameter());
  
  // ¿ªÊ¼¼Æʱ
  Stopwatch watch = new Stopwatch();
  watch.Start();
  
  // Á¬Ðø²åÈë1000Ìõ¼Ç¼
  for (int i = 0; i < 1000; i++)
  {
    cmd.CommandText = "insert into [test1] ([s]) values (?)";
    cmd.Parameters[0].Value = i.ToString();
    cmd.ExecuteNonQuery();
  }
  // Í£Ö¹¼Æʱ
  watch.Stop();
  Console.WriteLine(watch.Elapsed);
}
°¥~~~~ Ò»¸ö³£Ê¶ÐԵĴíÎó£¬ÎÒ¼Ó¼¸ÐдúÂë (ÐÂÔö´úÂë±ê¼Ç "// <-------------------")¡£
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
// ´´½¨Êý¾Ý¿âÎļþ
File.Delete("test1.db3");
SQLiteConnection.CreateFile("test1.db3");
DbProviderFactory factory = SQLiteFactory.Instance;
using (DbConnection conn = factory.CreateConnection())
{
  // Á¬½ÓÊý¾Ý¿â
  conn.ConnectionString = "Data Source=test1.db3";
  conn.Open();