Skip to end of banner
Go to start of banner

Ramsons Performance Expectations

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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

100

1000

10 000

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.

  • No labels