DISQLite3
所属分类:Pascal/Delphi编程
开发工具:Delphi
文件大小:5022KB
下载次数:17
上传日期:2014-04-27 16:13:14
上 传 者:
xuelun2003
说明: delphi操作sqlite的连接控件,使用过还不错
(delphi operation sqlite connection control, use too good)
文件列表:
DISQLite3 (0, 2008-10-31)
DISQLite3\D10 (0, 2008-10-31)
DISQLite3\D10\DISQLite3Api.dcu (411680, 2008-04-26)
DISQLite3\D10\DISQLite3Api.hpp (34113, 2008-04-26)
DISQLite3\D10\DISQLite3Api.obj (368418, 2008-04-26)
DISQLite3\D11 (0, 2008-10-31)
DISQLite3\D11\DISQLite3Api.dcu (411680, 2008-04-26)
DISQLite3\D11\DISQLite3Api.hpp (34048, 2008-04-26)
DISQLite3\D11\DISQLite3Api.obj (368418, 2008-04-26)
DISQLite3\D4 (0, 2008-10-31)
DISQLite3\D4\DISQLite3Api.dcu (390194, 2008-04-26)
DISQLite3\D4\DISQLite3Api.hpp (31799, 2008-04-26)
DISQLite3\D4\DISQLite3Api.OBJ (368856, 2008-04-26)
DISQLite3\D5 (0, 2008-10-31)
DISQLite3\D5\DISQLite3Api.dcu (389953, 2008-04-26)
DISQLite3\D5\DISQLite3Api.hpp (33725, 2008-04-26)
DISQLite3\D5\DISQLite3Api.obj (368723, 2008-04-26)
DISQLite3\D6 (0, 2008-10-31)
DISQLite3\D6\DISQLite3Api.dcu (406517, 2008-04-26)
DISQLite3\D6\DISQLite3Api.hpp (33750, 2008-04-26)
DISQLite3\D6\DISQLite3Api.obj (368768, 2008-04-26)
DISQLite3\D7 (0, 2008-10-31)
DISQLite3\D7\DISQLite3Api.dcu (407249, 2008-04-26)
DISQLite3\D7\DISQLite3Api.hpp (33825, 2008-04-26)
DISQLite3\D7\DISQLite3Api.obj (371673, 2008-04-26)
DISQLite3\D9 (0, 2008-10-31)
DISQLite3\D9\DISQLite3Api.dcu (409755, 2008-04-26)
DISQLite3\D9\DISQLite3Api.hpp (33767, 2008-04-26)
DISQLite3\D9\DISQLite3Api.obj (371023, 2008-04-26)
DISQLite3\Demos (0, 2008-10-31)
DISQLite3\Demos\Demo.db3 (0, 2008-10-31)
DISQLite3\Demos\DISQLite3_20_Million (0, 2008-10-31)
DISQLite3\Demos\DISQLite3_20_Million\1_Generate (0, 2008-10-31)
DISQLite3\Demos\DISQLite3_20_Million\1_Generate\DISQLite3_20_Million_Generate.dpr (6446, 2008-04-26)
DISQLite3\Demos\DISQLite3_20_Million\1_Generate_Mem_Helper (0, 2008-10-31)
DISQLite3\Demos\DISQLite3_20_Million\1_Generate_Mem_Helper\DISQLite3_20_Million_Generate_Mem_Helper.dpr (7034, 2008-04-26)
DISQLite3\Demos\DISQLite3_20_Million\2_Export (0, 2008-10-31)
DISQLite3\Demos\DISQLite3_20_Million\2_Export\DISQLite3_20_Million_Export.dpr (3319, 2008-04-26)
DISQLite3\Demos\DISQLite3_20_Million\3_Import (0, 2008-10-31)
DISQLite3\Demos\DISQLite3_20_Million\3_Import\DISQLite3_20_Million_Import.dpr (6962, 2008-04-26)
... ...
Introduction
This collection of projects demonstrates that DISQLite3 is well capable to
handle 20 million in very reasonable time. DISQLite3 by far outperforms other
Delphi database systems and even rivals big database players like MySql.
The individual projects in this folder show how to generate data, export to CSV,
and import from CSV. All projects handle the full number of 20 million records.
Requirements
* DISQLite3, DISQLite3 Pro required for Mem_Helper projects.
* DIUnicode for CSV import.
How to Run the Tests
1. Compile and run one of the Generate projects. They will create a
20_million_generate.db3 database file filled with random data.
2. Compile and run the Export project. This will export all 20 million records
from the generated table to a newly created CSV file.
3. Compile and run one of the Import projects. They will import all 20 million
records from the CSV file to a newly generated 20_million_import.db3 database.
Further Performance Improvements
The projects are set up to use no more than about 450 MB of memory for database
operations. Using more memory will speed up insertions and index creation. Refer
to the source code comments for details.
About 20% improvement can be achieved by using a fast memory manager like FastMM.
Approximate Timings
Generate with memory helper table: 11 Minutes CSV export:
8 Minutes Import with memory helper table: 13 Minutes
All timings measured on a Intel Core Duo 1.8 MHz, 1 GB memory, 5200 rpm hard
disk notebook system. Systems with faster hard disks and server hardware are
expected to show even better performance.
近期下载者:
相关文件:
收藏者: