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