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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<META NAME="GENERATOR" CONTENT="SGML-Tools 1.0.9">
<TITLE>NoSQL: More on speed</TITLE>
<LINK HREF="NoSQL-11.html" REL=next>
<LINK HREF="NoSQL-9.html" REL=previous>
<LINK HREF="NoSQL.html#toc10" REL=contents>
</HEAD>
<BODY BGCOLOR="#fff0e0">
<A HREF="NoSQL-11.html">Next</A>
<A HREF="NoSQL-9.html">Previous</A>
<A HREF="NoSQL.html#toc10">Contents</A>
<HR>
<H2><A NAME="s10">10. More on speed</A> </H2>
<P>I have done some benchmarking, though not at all exhaustive, to assess
the actual NoSQL speed with respect to other similar packages, and
here are the results :
<P>
<BLOCKQUOTE><CODE>
<PRE>
Input table:
No. of fields = 18
No. of records = 21000
Total size = 3.4 MB
Column names:
seq
NOME
PREF
INTERNO
REP
POSTO
CITTA
NODO
USERID
DEPTT
CAPIN
EMPTYPE
EMPNUM
ADDITIONAL
MGRCC
TELEFONO
MGR
MGRNUM
Machine: P200, 64MB RAM, 1GB Wide-SCSI HD
OS: Debian GNU/Linux 2.0 (kernel 2.0.35)
RDB (Perl):
time col POSTO NOME PREF USERID < table.rdb |
col POSTO NOME PREF | col NOME >/dev/null
real 0m13.937s
user 0m10.340s
sys 0m0.440s
NoSQL (awk):
time column POSTO NOME PREF USERID < table.rdb |
column POSTO NOME PREF | column NOME >/dev/null
real 0m3.910s
user 0m3.250s
sys 0m0.280s
Starbase (C):
time column POSTO NOME PREF USERID < table.rdb |
column POSTO NOME PREF | column NOME >/dev/null
real 0m1.230s
user 0m0.720s
sys 0m0.170s
-------------------
Input tables:
join1.rdb:
No. of fields = 4
No. of records = 21000
Total size = 660 KB
Column names:
NOME
PREF
INTERNO
REP
join2.rdb:
No. of fields = 4
No. of records = 21000
Total size = 700 KB
Column names:
NOME
POSTO
CITTA
NODO
Machine: P-II 233, 32MB RAM, 3GB EIDE U-DMA HD
OS: Debian GNU/Linux 2.0 (kernel 2.0.35)
RDB (Perl):
time jointbl -md < join1.rdb NOME join2.rdb >/dev/null
real 0m10.630s
user 0m10.540s
sys 0m0.020s
NoSQL (awk):
time jointable -a 1 -j NOME - join2.rdb < join1.rdb >/dev/null
real 0m1.402s
user 0m1.340s
sys 0m0.060s
Starbase (C):
time jointable -A1 -j NOME join1.rdb join2.rdb >/dev/null
real 0m0.881s
user 0m0.860s
sys 0m0.020s
</PRE>
</CODE></BLOCKQUOTE>
<P>
<HR>
<A HREF="NoSQL-11.html">Next</A>
<A HREF="NoSQL-9.html">Previous</A>
<A HREF="NoSQL.html#toc10">Contents</A>
</BODY>
</HTML>
|
