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

Links

NoSQL Home

Table of Contents

Wiki Editor's How-To

Text Formatting Rules

Wiki SandBox

www.strozzi.it on Twitter

Google Ads

Please Support NoSQL !

Session

User ID
Password

Campaigns

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.