1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="SGML-Tools 1.0.9">
<TITLE>NoSQL: Fast access methods</TITLE>
<LINK HREF="NoSQL-9.html" REL=next>
<LINK HREF="NoSQL-7.html" REL=previous>
<LINK HREF="NoSQL.html#toc8" REL=contents>
</HEAD>
<BODY BGCOLOR="#fff0e0">
<A HREF="NoSQL-9.html">Next</A>
<A HREF="NoSQL-7.html">Previous</A>
<A HREF="NoSQL.html#toc8">Contents</A>
<HR>
<H2><A NAME="s8">8. Fast access methods</A> </H2>
<P>The NoSQL operator 'search' may be used to execute one
of two fast access methods: binary or hashtable search.
<P>These methods are useful when the key field values of a
number of rows in an existing, large table is known
in advance, a common situation.
<P>One example of updating a table using these methods is
as follows. First, 'search' is used to quickly obtain 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 would be to use
'update' to combine the new and old tables into a
new, large table, which will still be in sort order
(both the old table and the new, small one will still
exist for backup and/or journaling purposes). Note that
the last step could be done in the background.
<P>More explanations on handling big tables can be found in
section
<A HREF="NoSQL-5.html#sec-bigtables">Big tables</A>.
<P>
<HR>
<A HREF="NoSQL-9.html">Next</A>
<A HREF="NoSQL-7.html">Previous</A>
<A HREF="NoSQL.html#toc8">Contents</A>
</BODY>
</HTML>
|
