Ramsons data volume
Instances: 21 million 000 000 records
Holdings: 23 million 000 000 records
Items: 29 million 000 000 records
Users: <tbd>500 000 records
Expected Response Time
Items, holdings, instances, users based on PTF reports for Item bulk edit in Morning Glory.
No. of records | Matched records (Identifiers) | Matched records (Query) | Are you sure? form | Confirmation form |
|---|---|---|---|---|
100 | 6 sec | 6 sec | 10 sec | 10 sec |
1000 | 40 sec | 40 sec | 1 min | 1 min |
10 000 | 8 min | 8 min | 13 min | 13 min |
100 000 | lack of prior data | lack of prior data | lack of prior data | Lack of prior data |
Observed Response Time
...
No. of records | Matched records (Identifiers) | Matched records (Query) | Are you sure? form | Confirmation form |
|---|---|---|---|---|
Items (Identifiers: status Missing → Unknown, Query: status Unknown → Missing, member tenant) | ||||
100 | 9 sec (expected: 6 sec) | 9 sec (expected: 6 sec) | 2 sec (expected: 10 sec) | I: 6.4 sec Q: 6.4 sec (expected: 10 sec) |
1000 | 95 sec (expected: 40 sec) | 93 sec (expected: 40 sec) | 3 sec (expected: 1 min) | I: 78 sec (1.3 min) Q: 102 sec (1.7 min) (expected: 1 min) |
10 000 | 763 sec (12.7 min) (expected: 8 min) | 580 sec (9.7 min) (expected: 8 min) | 5 sec (expected: 13 min) | I: 654 sec (10.9 min) Q: 741 sec (12.4 min) (expected: 13 min) |
100 000 | needs data | needs data | needs data | needs data |
Instances (Identifiers: discovery suppressing → true + set to items/holdings, Query: discovery suppressing + set to items/holdings → false, member tenant) | ||||
100 | 14 sec (expected: 6 sec) | 13 sec (expected: 6 sec) | 3 sec (expected: 10 sec) | I: 27 sec Q: 53 sec (expected: 10 sec) |
1000 | 98 sec (expected: 40 sec) | 89 sec (expected: 40 sec) | 6 sec (expected: 1 min) | I: 295 sec (4.9 min) Q: 252 sec (4.2 min) (expected: 1 min) |
10 000 | 872 sec (14.5 min) (expected: 8 min) | 705 sec (11.8 min) (expected: 8 min) | 10 sec (expected: 13 min) | I: 3058 sec (51.0 min) Q: 2194 sec (36.6 min) (expected: 13 min) |
100 000 | needs data | needs data | needs data | needs data |
Holdings ( ) | ||||
100 | (expected: 6 sec) | (expected: 6 sec) | (expected: 10 sec) | (expected: 10 sec) |
1000 | (expected: 40 sec) | (expected: 40 sec) | (expected: 1 min) | (expected: 1 min) |
10 000 | (expected: 8 min) | (expected: 8 min) | (expected: 13 min) | (expected: 13 min) |
100 000 | needs data | needs data | needs data | needs data |
Users ( ) | ||||
100 | (expected: 6 sec) | (expected: 6 sec) | (expected: 10 sec) | (expected: 10 sec) |
1000 | (expected: 40 sec) | (expected: 40 sec) | (expected: 1 min) | (expected: 1 min) |
10 000 | (expected: 8 min) | (expected: 8 min) | (expected: 13 min) | (expected: 13 min) |
100 000 | needs data | needs data | needs data | needs data |
Examples of queries:
Item records:
(items.status_name == "Available") - returns 22 records in Sprint testing environment. Query tool returns records immediately, bulk edit populates Matching records form in 9 sec.
(temporary_location.name is null/empty false) - returns 3082 records, first 100 in Query tool in 12 sec. 3082 records in bulk edit displays after 2 min 15 sec
Holdings records: I’m not able to run any query that would return data but I would run a query based on location or statistical code
(permanent_location.code in ("UC/HP/ASR/LawSupr")) - returns 258 records in Sprint testing environment instantly. Bulk edit populates Matching records form in (I gave up after 8 minutes)
Instance:
(instance.discovery_suppress is null/empty true) - returns 44 records in the Sprint testing environment. Query tool returns records instantly , bulk edit populates Matched records in 12 sec
(instance.title contains "train") - returns one record on snapshot. Query tool displays the record instantly, bulk edit populates Matched record in 6 seconds.
...