效率比较展示以及SQLite支持?

Aug 30, 2012 at 5:50 AM

作为数据处理最关心的还是效率问题。最好能有个效率比较的示意图。

我想添加SQLite的支持需要如何去做?有没有文档提供?

Coordinator
Oct 15, 2012 at 5:40 AM

您好,您可以获取最新的源代码,然后按照以下步骤操作:

  1. 打开KylinORM>Data>Parser目录,按照MySqlParser.cs的格式编写Sql语法解析器。
  2. 在SqlParserProvider.cs文件的初始化函数中添加RegistBuilder(EDataProviderType.SqlLite, typeof(SqlServerCeParser)),EDataProviderType.SqlLite枚举需要您自行添加
  3. 打开KylinORM.Data.MySql目录,按照MySqlHelperAdapter.cs和MySqlHelper.cs的格式编写数据库驱动
Coordinator
Oct 21, 2012 at 1:19 AM
Edited Oct 21, 2012 at 2:27 AM

您好,以下是KylinORM和网上常见的ORM性能测试案例的对比结果:

===== NClay.Test.vshost.exe Test 0 =======================
test insert performance use: 4953.125 ms
test typed query performance use: 281.25 ms
test read performance use: 390.625 ms
test load performance use: 31.25 ms
test update all fields performance use: 1484.375 ms
test update dirty fields performance use: 62.5 ms
0
0
0
test delete performance use: 234.375 ms

===== KylinORM.Test.vshost.exe Test 0 =======================
test insert performance use: 4218.75 ms
test typed query performance use: 62.5 ms
test read performance use: 453.125 ms
test load performance use: 31.25 ms
test update all fields performance use: 78.125 ms
test update dirty fields performance use: 78.125 ms
0
0
0
test delete performance use: 218.75 ms

为了体现公平性,KylinORM在测试插入操作时已关闭 SELECT SCOPE_IDENTITY() AS NewID; 功能。测试案例稍后会上传到 http://kylinorm.codeplex.com/documentation