SQLite插入1000行数据居然耗时9秒。。

2016-05-09 08:57:40 1.2k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Windows Mobile下SQLite的Native C++轻量封装实践 SQLite是一种嵌入式关系型数据库引擎，其核心设计强调零配置、自包含与事务可靠性；在资源受限的嵌入式系统中，需绕过高级抽象、禁用异常与RTTI，并基于原生C API构建确定性访问层。Native C++封装能规避托管运行时开销，满足硬实时、低内存占用及跨语言调用需求，广泛应用于工业PDA、医疗终端、电力巡检等离线场景。本文聚焦Windows Mobile 6.5（ARMV4I/CE 5.2）平台，详解如何通过纯C导出接口、手动临界区同步、WAL日志适配与路径归一化等关键技术，实现稳定、可预测、可部署的SQ 阅读详情

以下为代码

  static void Main(string[] args)

        {

            string directoryName = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);

            SQLiteConnection connection = new SQLiteConnection("Data Source=" + directoryName + @"\Test.db");

            connection.Open();



            SQLiteCommand commandClearDB = new SQLiteCommand("delete FROM highscores", connection);

            commandClearDB.ExecuteNonQuery();



            DateTime now = DateTime.Now;

            for (int i = 0; i < 1000; i++)

            {

                SQLiteCommand command = new SQLiteCommand("insert into highscores (name, score) values ('Me', 3000)", connection);

                command.ExecuteNonQuery();

            }



            SQLiteCommand commandCount = new SQLiteCommand("select count(*) from highscores", connection);

            object count = commandCount.ExecuteScalar();



            string tip = ((DateTime.Now - now)).TotalMilliseconds.ToString();

            Console.WriteLine(tip);

            Console.WriteLine("数据行:" + count);

            Console.ReadKey();

        }