How does addedValues stack up when conducting a search? After all, this was one of the purposes of addedvalues. We'll let the numbers do the talking for themselves. Following is a table of actual times measured running addedValues on a G3/400 under OS 9 and Frontier 9.
Searches were conducted using one single criteria (say name), two criteria (say name & city), 2 criteria, one of which being a multiple choice (picking 2 regions from a menu) and 3 criteria. Search criteria were tested repeatedly and also through substitution, always generating results similar to those shown below.
Note: there are 60 ticks in a second.
| Single criteria | Two criteria | ||
|---|---|---|---|
|
Search
Results |
Ticks |
Search
Results |
Ticks |
| 1 | 1 | 1 | 33 |
| 3 | 1 | 6 | 34 |
| 4 | 2 | 7 | 67 |
| 5 | 2 | 11 | 68 |
| 14 | 3 | 15 | 66 |
| 16 | 4 | 20 | 68 |
| 21 | 5 | 27 | 53 |
| 30 | 7 | 35 | 290 |
| 30 | 7 | 38 | 156 |
| 68 | 14 | 44 | 156 |
| 98 | 17 | 70 | 206 |
| 100 | 22 | 85 | 161 |
| 109 | 26 | 168 | 351 |
| 154 | 7 | ||
| 154 | 4 | ||
194 |
41 | 2 criteria, 1 multiple | |
| 202 | 71 | 92 | 677 |
| 233 | 49 | 106 | 856 |
| 270 | 11 | 301 | 702 |
| 270 | 10 | 370 | 831 |
| 324 | 71 | ||
| 374 | 93 | ||
| 398 | 98 | 3 criteria | |
| 1809 | 836 | 20 | 252 |
| 4362 | 2489 | 76 | 179 |