Recent Pages

Commands at a glance
edittable: trivial tabl ...
indextable: generate ta ...
NoSQL Utilities
Text Formatting Rules
Site SandBox
Change Management
Wiki Editor's How-To
Site Terms of Use
Site Copyright


NoSQL Home
Table of Contents
Wiki Editor's How-To
Text Formatting Rules
Wiki SandBox on Twitter


Google Ads

Please Support NoSQL !


User ID

Campaigns petition banner

Fast Access Methods

The NoSQL operator 'searchtable' may be used to execute one of two fast access methods: binary or hashtable search.

These methods are useful when the key field values of a number of rows in an existing large table are known in advance, a common situation.

One example of updating a table using these methods is as follows. First, 'search' is used to obtain quickly a new small table consisting of the desired rows from the existing large table. Then 'edittable' is used to update the data in the new table, including generating new rows, changing some rows, and marking certain rows for deletion if desired. The next stage is to use 'update' to combine the new and old tables into a single large table, which will remain in sort order. Both the old table and the new small one continue to exist for backup and/or journaling purposes. The last step could be done in the background.

More explanations on handling big tables can be found on page Big tables.

Trackbacks (1) | New trackback | Comments (0) | Print

This Web Site is Copyright © 2007,2008,2009,2010 Carlo Strozzi, Some Rights Reserved
site map | recent changes | terms of use