Over the past few days, I have discussed the popularity of ORM performance, and it is even a bit of gunpowder. It is said that our ORM is good and the performance is high. Of course, the best thing we use is the best. We also want to do better without it. The newlife group has a MB SQLite database. Many people have concerns about the performance of newlife. xcode. The actual performance of xcode is as follows:
5.8 million MB SQLite database, about of the DNS data of the actual project
2. newlife. xcode supports mainstream databases without the need to implement the interface by yourself. [MSSQL, MySQL, mongoel, access, SQLite, PostgreSQL, Firebird]
3. Other features of xcode, such as reverse engineering of databases, will not be mentioned. Let's take a look at the following resource links.
Http://www.cnblogs.com/asxinyu/archive/2012/06/02/2532210.html
4. newlfe. xcode has always adhered to the principle of open source. This test discloses the following:Source code:
- Newlife. xcode source code [time to stop downloading]
- Latest Version of newlife Components
- Source code of the test project website and actual database of MB SQLite
5. Wu huiyou, don't like it, you can comment on it, you can give comments, you can ask questions, but don't attack Test process and result 1. Decompress dns_agent.rar
2. Decompress dns_data.rar to the data directory or not. There is 5 million data for testing.
3. Run xdns.exe, select install and run, and install and run the DNS service.
[Well, people who know what to do will know. I can't say it's too detailed. I don't need to use it to test performance]
4. Configure the IIS Site to point to the web and enter the management platform. The default account is admin/admin.
5. Configure the Intranet machine DNS to point to the DNS server and test the DNS function [same as 3rd]
[Download, newlife. xcode SourceCodeRare opportunities]
Xdns: http://www.kuaipan.cn/file/id_4279479643933433.html 5 million database download: http://www.kuaipan.cn/file/id_2378544298628850.htm
Newlife. xcode source code: [Stop downloading. It will be published at other times] Newlife. xcoder builder: http://www.kuaipan.cn/file/id_4279479643933425.html Newlife components latest: http://www.kuaipan.cn/file/id_4279479643933427.html Check the test results on my server: 1. After entering the system, click DNS System in the upper right corner, as shown in figure 2. The menu on the right is the DNS management interface. It mainly looks at [History Management], as shown in 3. After you enter History Management for the first time, you can view the execution time at the minimum corner of the page, as shown in figure 4. Click the tab and test several pages, which are pages 256258, and. View results
Too many items ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- The above time, there must be some differences on different machines, but it should not be too big. The above pages are all directly transferred. If you click the next page, it will be within ms, because the first time it is slow, the query speed varies depending on the situation. 5. Check the query test. The query keyword "config.dengluqi.net" is not indexed. Result: For more than 5 million data records, find more than 0.2 million data records. What is the result? Let's look at the page after the query. We can randomly select two pages with a larger number: If it is faster than newlife. xcode under the same conditions, you can have dinner with stone. Haha, by the way, make a friend.
Publish via wiz
