Synopse Big Table 1.15

In category

DB-Aware Components > Other > Tables

Description

An open source Delphi unit for very fast data storage and access. If you just need to save raw data on disk, and retrieve it with an unique ID number, you can use this unit, which is much faster than any database engine.

TSynBigTable is a class to store huge amount of data, just specified by an integer ID:

• data is stored in an unique file
• data is appended at the end of this file at adding (but use a caching mechanism for immediate adding)
• use a temporary in memory adding, till the UpdateToFile method is called
• retrieval is very fast (can't be faster IMHO)
• data items can be deleted
• file can be packed using the Pack method in order to retrieve free space from deleted entries (sounds like a VACUUM command, but faster)
• total size of file has no limit (but your hard disk, of course)
• limit of one data block depends on RAM (RawByteString is used as storage for data block)
• before Delphi 2007, much faster when using FastMM4 memory manager - see Project1.dpr source file
• after profiling, most of the time is spent in the Windows kernel, waiting from hard disk write of raw data; in all cases, this class is much faster than any SQL engine storing BLOB, and than plain Win32 files.

Informations

• Status: Fully functional
• Source: FW
• Size: 351 031kB

Platforms:

• Delphi 2005 (VCL)
• Delphi 2006 (Win32)
• Delphi 2007 (VCL)
• Delphi 2009
• Delphi 2010
• Delphi 6
• Delphi 7
• Delphi XE
• Delphi XE 2

Downloads

• Delphi 2005 (VCL) , Delphi 2006 (Win32) , Delphi 2007 (VCL) , Delphi 2009 , Delphi 2010 , Delphi 6 , Delphi 7 , Delphi XE , Delphi XE 2