Ramsons data volume
Instances: 21 000 000 records
Holdings: 23 000 000 records
Items: 29 000 000 records
Users: 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
Items, holdings, instances, users
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 | 9 sec | 2 sec | I: 6.4 sec Q: 6.4 sec |
1000 | 95 sec | 93 sec | 3 sec | I: 78 sec (1.3 min) Q: 102 sec (1.7 min) |
10 000 | 763 sec (12.7 min) | 580 sec (9.7 min) | 5 sec | I: 654 sec (10.9 min) Q: 741 sec (12.4 min) |
100 000 | ||||
Instances (Identifiers: discovery suppressing → true + set to items/holdings, Query: discovery suppressing + set to items/holdings → false, member tenant) | ||||
100 | 14 sec | 13 sec | 3 sec | I: 27 sec Q: 53 sec |
1000 | 98 sec | 89 sec | 6 sec | I: 295 sec (4.9 min) Q: 252 sec (4.2 min) |
10 000 | 872 sec (14.5 min) | 705 sec (11.8 min) | 10 sec | I: 3058 sec (51.0 min) Q: 2194 sec (36.6 min) |
100 000 | ||||
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
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.
Users
(users.active == "true") returns 90 314 records in Sprint testing environment. Query tools returns first 100 records in 11 sec, bulk edit populated the Matched record in 19 minutes. The same query run on snapshot returns the 44 records in Query tool and Bulk edit instantly.