SDSM:Performance Measurements

From SMUSwiki
Revision as of 11:31, 6 September 2024 by Darren.duncan (talk | contribs) (Add date change and impersonation screens)
Jump to navigation Jump to search


This document consists of multiple parts; for a directory to all of the parts, see SDSM:Index.

Description

This part of the SDS Modernization (SDSM) document provides a list of SDS user interface screens and performance measurements for them as seen on its production instance (https://sds.smus.ca).

The list of screens is not exhaustive, and serves as a representative sample, in particular to provide visibility into historical progress of the SDS Modernization (SDSM) project with respect to how it improved the measured performance of SDS features over time.

See also the document part List of Screens that provides some context for this part.

This document part is organized first by access path for the screens, meaning by the path one takes through the main menus to reach them, and then for each screen, at least one or typically multiple performance measurements at different dates are given, organized earliest to latest.

Any given measurement should be considered to only be valid for the date on which it was measured, and not necessarily for any earlier or later date; but in practice, if it was measured again on the day this SDSM document was being read, it would likely be similar to the latest reported.

Every measurement is of the simple act of loading or refreshing a screen as a read-only action that doesn't try to add/edit/remove/etc data, unless otherwise explicitly stated.

Each measurement is within the context of a specific user, campus, and date, and sometimes other variables, since the app may behave differently and have different performance characteristics that depend on such, and comparisons over time or repeatable tests need to keep them consistent; most contextual variables only exist or apply for a user who is logged in.

These are the meanings of some context-defining terms:

  • Measured on: The actual real world date the measurement was made.
  • When as: The user that the app is is currently pretending is the current logged in user, via an impersonation, if it isn't the actual logged in user.
  • Effective date: The date that the app is currently pretending is the current date, if it isn't the real world date.
  • Effective campus: The campus that the app is currently pretending is where the logged in user is located.

If a measurement does not have an explicitly stated effective date, this should be read as if it were the same as measured on.

If a measurement does not have an explicitly stated effective campus, this should be read as if it were Senior School.

These are who the effective users are:

  • DRD: Darren Duncan, who has a debug role, is effectively a staff member, is not a teacher or parent or student.
  • RC: Richard Curry, who is both a teacher and a parent.
  • CA: Carol Adamson, who is a teacher.

Typically each measurement is taken at least 3 times back to back and then the one with the shortest time is the one used.

RETURN

SDS Gavintech: Public Home

The SDS Gavintech: Public Home screen is where an app user typically starts when they first visit the app and have not yet authenticated or logged in to it.

https://sds.smus.ca

Measured on Thu 2024 Aug 29, when not logged in:

   Page generation time: 0.027
   Total SQL Queries: 4
   Total SQL Cache Hits: 1
   Total Local Cache Hits:
   Total Memcache Hits:
   Memory Usage: 2048K
   Realpath Usage: 229K

Measured on Fri 2024 Sep 6, when not logged in:

   Page generation time: 0.016
   Total SQL Queries: 4
   Total SQL Cache Hits: 1
   Total Local Cache Hits:
   Total Memcache Hits:
   Memory Usage: 2048K
   Realpath Usage: 322K

RETURN

SDS Gavintech: Private Home

The SDS Gavintech: Private Home screen is where an app user typically starts once they have authenticated or logged in to it.

https://sds.smus.ca

Measured on Thu 2024 Aug 29, when as DRD, effective date Thu 2024 Aug 29:

   Page generation time: 0.519
   Total SQL Queries: 563
   Total SQL Cache Hits: 4026
   Total Local Cache Hits: 26
   Total Memcache Hits:
   Memory Usage: 14336K
   Realpath Usage: 277K

Measured on Fri 2024 Sep 6, when as DRD, effective date Thu 2024 Aug 29:

   Page generation time: 0.157
   Total SQL Queries: 51
   Total SQL Cache Hits: 3536
   Total Local Cache Hits: 21
   Total Memcache Hits:
   Memory Usage: 4096K
   Realpath Usage: 335K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3:

   Page generation time: 1.639
   Total SQL Queries: 1814
   Total SQL Cache Hits: 7220
   Total Local Cache Hits: 101
   Total Memcache Hits:
   Memory Usage: 36864K
   Realpath Usage: 190K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3:

   Page generation time: 0.264
   Total SQL Queries: 205
   Total SQL Cache Hits: 3598
   Total Local Cache Hits: 59
   Total Memcache Hits:
   Memory Usage: 6144K
   Realpath Usage: 248K

Measured on Thu 2024 Aug 29, when as RC, effective date Mon 2024 Jun 3:

   Page generation time: 1.956
   Total SQL Queries: 1911
   Total SQL Cache Hits: 8673
   Total Local Cache Hits: 111
   Total Memcache Hits:
   Memory Usage: 38912K
   Realpath Usage: 253K

Measured on Fri 2024 Sep 6, when as RC, effective date Mon 2024 Jun 3:

   Page generation time: 0.338
   Total SQL Queries: 225
   Total SQL Cache Hits: 5008
   Total Local Cache Hits: 63
   Total Memcache Hits:
   Memory Usage: 6144K
   Realpath Usage: 304K

Measured on Thu 2024 Aug 29, when as CA, effective date Mon 2024 Jun 3:

   Page generation time: 2.406
   Total SQL Queries: 2489
   Total SQL Cache Hits: 12037
   Total Local Cache Hits: 472
   Total Memcache Hits:
   Memory Usage: 49152K
   Realpath Usage: 193K

Measured on Fri 2024 Sep 6, when as CA, effective date Mon 2024 Jun 3:

   Page generation time: 0.354
   Total SQL Queries: 236
   Total SQL Cache Hits: 8542
   Total Local Cache Hits: 66
   Total Memcache Hits:
   Memory Usage: 6144K
   Realpath Usage: 303K

RETURN

SDS Gavintech: Date -> change

Date -> change

https://sds.smus.ca/index.php?next_page=time/year_switch.php

Measured on Thu 2024 Aug 29, when as DRD, effective date Thu 2024 Aug 29:

   Page generation time: 0.552
   Total SQL Queries: 544
   Total SQL Cache Hits: 3973
   Total Local Cache Hits: 10
   Total Memcache Hits:
   Memory Usage: 14336K
   Realpath Usage: 228K

Measured on Fri 2024 Sep 6, when as DRD, effective date Thu 2024 Aug 29:

   Page generation time: 0.091
   Total SQL Queries: 30
   Total SQL Cache Hits: 3492
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 47104K
   Realpath Usage: 332K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3:

   Page generation time: 1.388
   Total SQL Queries: 1584
   Total SQL Cache Hits: 7084
   Total Local Cache Hits: 11
   Total Memcache Hits:
   Memory Usage: 34816K
   Realpath Usage: 249K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3:

   Page generation time: 0.149
   Total SQL Queries: 30
   Total SQL Cache Hits: 3492
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 4096K
   Realpath Usage: 369K

Measured on Thu 2024 Aug 29, when as RC, effective date Mon 2024 Jun 3:

   Page generation time: 1.631
   Total SQL Queries: 1683
   Total SQL Cache Hits: 8521
   Total Local Cache Hits: 17
   Total Memcache Hits:
   Memory Usage: 34816K
   Realpath Usage: 261K

Measured on Fri 2024 Sep 6, when as RC, effective date Mon 2024 Jun 3:

   Page generation time: 0.204
   Total SQL Queries: 52
   Total SQL Cache Hits: 4891
   Total Local Cache Hits: 7
   Total Memcache Hits:
   Memory Usage: 6144K
   Realpath Usage: 376K

Measured on Thu 2024 Aug 29, when as CA, effective date Mon 2024 Jun 3:

   Page generation time: 2.068
   Total SQL Queries: 2268
   Total SQL Cache Hits: 11891
   Total Local Cache Hits: 377
   Total Memcache Hits:
   Memory Usage: 45056K
   Realpath Usage: 204K

Measured on Fri 2024 Sep 6, when as CA, effective date Mon 2024 Jun 3:

   Page generation time: 0.202
   Total SQL Queries: 61
   Total SQL Cache Hits: 8438
   Total Local Cache Hits: 11
   Total Memcache Hits:
   Memory Usage: 4096K
   Realpath Usage: 320K

RETURN

SDS Gavintech: You are -> impersonate

You are -> impersonate

https://sds.smus.ca/index.php?next_page=impersonation.php

Measured on Thu 2024 Aug 29, when as DRD, effective date Thu 2024 Aug 29:

   Page generation time: 9.97
   Total SQL Queries: 11882
   Total SQL Cache Hits: 27019
   Total Local Cache Hits: 240
   Total Memcache Hits:
   Memory Usage: 219136K
   Realpath Usage: 228K

Measured on Fri 2024 Sep 6, when as DRD, effective date Thu 2024 Aug 29:

   Page generation time: 9.32
   Total SQL Queries: 11349
   Total SQL Cache Hits: 26447
   Total Local Cache Hits: 227
   Total Memcache Hits:
   Memory Usage: 208896K
   Realpath Usage: 378K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3:

   Page generation time: 9.601
   Total SQL Queries: 11889
   Total SQL Cache Hits: 30468
   Total Local Cache Hits: 240
   Total Memcache Hits:
   Memory Usage: 219136K
   Realpath Usage: 243K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3:

   Page generation time: 9.664
   Total SQL Queries: 11360
   Total SQL Cache Hits: 25748
   Total Local Cache Hits: 227
   Total Memcache Hits:
   Memory Usage: 208896K
   Realpath Usage: 282K

RETURN