QuickSearch Results

DB-Aware Components > Direct DB Access > Memory Tables

Description

If you have ever wanted to store data temporarily in your Delphi, C++ Builder or Kylix application, and you at the same time wanted full access to the data as if they were stored in a database table, you have the right solution here. kbmMemTable is a full TDataset compatible in memory table loaded with functionality.

• Std.version is Free/Infoware.
• Pro version is free for holders of kbmMW commercial developer licenses.
• No need for the BDE. Make a full fledged application with data storage using only kbmMemTable.
• Fastest memory table around.
• Full expression filtering supported for Delphi 5/6/7/8 and BCB 5/6.
• Advanced index support incl. filtered indexes and allot more.
• Full support for search and locate both using indexes and not.
• International sort orders supported for indexes.
• In memory compression of data.
• Full range of fields supported incl. blobs.
• Full support for all data aware controls.
• Easy interaction with other TDataset descendants.
• Supports multiple cursors to the same physical in memory data.
• Full support for transactions (StartTransaction, Commit, Rollback).
• Supports Win32, Linux and safe .Net code.
• and much more...

Informations

• Status: Fully functional
• Source: Included
• Size: 529kB

Platforms: C2k6, CB3, CB4, CB5, CB6, D2005, D2006, D3, D4, D5, D6, D7

Kylix > Database > Tables

Description

If you have ever wanted to store data temporarily in your Delphi, C++ Builder or Kylix application, and you at the same time wanted full access to the data as if they were stored in a database table, you have the right solution here. kbmMemTable is a full TDataset compatible in memory table loaded with functionality.

• Std.version is Free/Infoware.
• Pro version is free for holders of kbmMW commercial developer licenses.
• No need for the BDE. Make a full fledged application with data storage using only kbmMemTable.
• Fastest memory table around.
• Full expression filtering supported for Delphi 5/6/7/8 and BCB 5/6.
• Advanced index support incl. filtered indexes and a lot more.
• Full support for search and locate both using indexes and not.
• International sort orders supported for indexes.
• In memory compression of data.
• Full range of fields supported incl. blobs.
• Full support for all data aware controls.
• Easy interaction with other TDataset descendants.
• Supports multiple cursors to the same physical in memory data.
• Full support for transactions (StartTransaction, Commit, Rollback).
• Comprehensive help file available.
• Delphi 3/4/5/6/7/8/2005, BCB 3/4/5/6, Kylix 1/2/3 supported.
• Supports Win32, Linux and safe .Net code.
• and much more...

Informations

• Status: Fully functional
• Source: Included
• Size: 529kB

Platforms: KLX1, KLX2, KLX3

DB-Aware Components > Direct DB Access > SQL

Description

SQLDAC - is a database-independent layer that defines a common interface for access to SQL database servers. Interaction with a database is carried out through the corresponding database adapters.

Only MS Access ADO adapter supported at the moment.

• TDacConnection - the connection component, that defines name of Adapter bpl module and Connection string. Connection string implementation depends of corresponding database level.
• TDacDataSet - is the TkbmMemTable descendant, database independent in-memory dataset with flexible resolving capabilities. Insert, Update, Delete, RefreshRecord operations are implemented by means of InsertSQL, UpdateSQL, DeleteSQL and GetRecordSQL SQL-statement properties. All SQL statements can be saved to and loaded from application database DataSet repository in design-time.

Requires TkbmMemTable.

Informations

• Status: Fully functional
• Source: On request
• Size: 1 120kB

Platforms: CB6

DB-Aware Components > DB Access > SQL

Description

SuperFastDistinct. is the fastest way on the planet to obtain all the distinct values from a table. All you need is a TTable (or equivalent) and an index on the field(s) you wish to retrieve.

• Up to 5x, 10x, 100x faster than SQL
• Over 500x faster than SQL on large LAN based tables over the network (non-Client/Server)
• Uses up to 1,000x less memory than SQL on large tables compared to database engines like Paradox and others.
• Prevent computer slow downs and disk thrashing. Improve network throughput.
• Super easy. Requires only 1 line of code.

A single call to our SuperFastDistinct() procedure is 5x, 10x, even 100x faster than the SQL statement that it replaces:

Select distinct col1 [,col2,col3] from Table1 order by col1 [,col2,col3]

Your users will no longer have to stare at the hourglass while the slow SQL distinct query completes. SuperFastDistinct. can give you the distinct values 5x, 10x to 100x faster than SQL. All you need is an index on the field(s) and our proprietary algorithm will traverse the index to return the distinct values in sub-second speeds even on million row tables. Not only will this make your users happy, but your web server or database server can support more users without consuming vasts amounts of memory.

Features:

• SuperFastDistinct. works with embedded databases, single user databases, multi-user LAN databases, Client/Server databases, and in-memory tables. Anywhere you can use a Table component, you can use SuperFastDistinct..
• SuperFastDistinct. works with any index, including compound indexes.
• Let�s say you have an index made up of the fields: Country, State, City. You have a choice of retrieving the distinct Countries, or the distinct Country & State combinations, or the distinct Country & State & City combinations. (You must choose one or more of the leading index fields. You can�t get distinct Cities from this compound index because the index does not start with City. You would need to create another index on City if you want just the distinct cities.)
• Add a Filter or a Range to get a subset of distinct values from the table.
• SuperFastDistinct. is thread safe.
• Save the distinct values to any TStrings object like a TComboBox, TListBox, TMemo, or to another database table or even to a memory table like kbmMemTable etc..
• The results are automatically sorted in index order.
• Unlike SQL, SuperFastDistinct. will not consume a lot of memory and will run fast even on machines with very little memory. Memory consumption is extremely low.
• SQL engines like Paradox/BDE can consume vast amounts of memory when retrieving the distinct values from a large table. During our benchmark tests, some of the SQL engines consumed over 100 MB of memory when retrieving the distinct values from a 1 million row table. By comparison, SuperFastDistinct. used only 1 kilobyte of memory to retrieve the same distinct values from the same 1 million row table.
• SQL is not required. If your database doesn�t support SQL, that�s fine because SuperFastDistinct. doesn�t use SQL. SuperFastDistinct. works on any TTable component or 3rd party table component like DBISAM, Advantage, NexusDb, dbExpress, and even kbmMemTable. Support for other databases can be added by the user and we will be releasing support for more databases over the next few months.
• SuperFastDistinct. comes with complete source code.
• Works with IntraWeb(TM) from AtoZed and most web based applications that can compile Delphi code.
• SuperFastDistinct. is 100% Delphi code and runs on Delphi 4 through Delphi 2006 Win32 and Delphi Vcl .NET. All of the SuperFastDistinct. code is stored in a single Delphi unit called SuperFastDis.Pas. There are no DLL�s or additional files to install to your client�s machine. SuperFastDistinct. gets compiled directly into your .exe file. Getting super fast distinct values from your table is just one function call away.
• No royalties.

Download our benchmark demo and see the speed improvements for yourself.

Informations

• Status: Demo only
• Source: Included
• price: $89
• Size: 5 720kB

Platforms: C2k6, CB4, CB5, CB6, D2005, D2006, D4, D5, D6, D7