SDSM:Performance Measurements: Difference between revisions

From SMUSwiki
Jump to navigation Jump to search
No edit summary
(Previous change added a few more screens; this change tweaked a few numbers.)
Line 337: Line 337:
default senior campus only, default day+boarding:
default senior campus only, default day+boarding:


     Page generation time: 0.205
     Page generation time: 0.185
     Total SQL Queries: 38
     Total SQL Queries: 38
     Total SQL Cache Hits: 3501
     Total SQL Cache Hits: 3501
Line 343: Line 343:
     Total Memcache Hits:
     Total Memcache Hits:
     Memory Usage: 4096K
     Memory Usage: 4096K
     Realpath Usage: 319K
     Realpath Usage: 253K


Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3,
Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3,
Line 381: Line 381:
all campuses, default day+boarding:
all campuses, default day+boarding:


     Page generation time: 0.209
     Page generation time: 0.197
     Total SQL Queries: 38
     Total SQL Queries: 38
     Total SQL Cache Hits: 3501
     Total SQL Cache Hits: 3501
     Total Local Cache Hits: 8
     Total Local Cache Hits: 8
     Total Memcache Hits:
     Total Memcache Hits:
     Memory Usage: 4096K
     Memory Usage: 8192K
     Realpath Usage: 286K
     Realpath Usage: 310K


Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3,
Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3,
Line 433: Line 433:
default for all filters:
default for all filters:


     Page generation time: 8.291
     Page generation time: 7.921
     Total SQL Queries: 9751
     Total SQL Queries: 9751
     Total SQL Cache Hits: 17131
     Total SQL Cache Hits: 17131
Line 439: Line 439:
     Total Memcache Hits:
     Total Memcache Hits:
     Memory Usage: 169984K
     Memory Usage: 169984K
     Realpath Usage: 272K
     Realpath Usage: 260K


[[#top|RETURN]]
[[#top|RETURN]]
Line 463: Line 463:
default all students:
default all students:


     Page generation time: 9.438
     Page generation time: 8.739
     Total SQL Queries: 11065
     Total SQL Queries: 11065
     Total SQL Cache Hits: 19658
     Total SQL Cache Hits: 19658
Line 469: Line 469:
     Total Memcache Hits:
     Total Memcache Hits:
     Memory Usage: 206848K
     Memory Usage: 206848K
     Realpath Usage: 322K
     Realpath Usage: 239K


[[#top|RETURN]]
[[#top|RETURN]]
Line 493: Line 493:
default just picklist with blank option chosen:
default just picklist with blank option chosen:


     Page generation time: 13.455
     Page generation time: 12.326
     Total SQL Queries: 15408
     Total SQL Queries: 15408
     Total SQL Cache Hits: 10584
     Total SQL Cache Hits: 10584
Line 499: Line 499:
     Total Memcache Hits:
     Total Memcache Hits:
     Memory Usage: 280576K
     Memory Usage: 280576K
     Realpath Usage: 324K
     Realpath Usage: 313K


Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3,
Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3,
Line 515: Line 515:
picklist option "Sports: Basketball" chosen:
picklist option "Sports: Basketball" chosen:


     Page generation time: 13.127
     Page generation time: 12.338
     Total SQL Queries: 15408
     Total SQL Queries: 15408
     Total SQL Cache Hits: 10584
     Total SQL Cache Hits: 10584
Line 521: Line 521:
     Total Memcache Hits:
     Total Memcache Hits:
     Memory Usage: 280576K
     Memory Usage: 280576K
     Realpath Usage: 291K
     Realpath Usage: 300K


[[#top|RETURN]]
[[#top|RETURN]]

Revision as of 21:18, 8 September 2024


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

SDS Gavintech: Staff Menu -> Attendance -> Input absences

Staff Menu -> Attendance -> Input absences

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

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, default day+boarding: 

   Page generation time: 8.524
   Total SQL Queries: 10075
   Total SQL Cache Hits: 31294
   Total Local Cache Hits: 5291
   Total Memcache Hits:
   Memory Usage: 178176K
   Realpath Usage: 243K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, default day+boarding: 

   Page generation time: 0.185
   Total SQL Queries: 38
   Total SQL Cache Hits: 3501
   Total Local Cache Hits: 8
   Total Memcache Hits:
   Memory Usage: 4096K
   Realpath Usage: 253K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, day students only: 

   Page generation time: 9.103
   Total SQL Queries: 10049
   Total SQL Cache Hits: 28508
   Total Local Cache Hits: 5260
   Total Memcache Hits:
   Memory Usage: 178176K
   Realpath Usage: 237K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, day students only: 

   Page generation time: 0.197
   Total SQL Queries: 39
   Total SQL Cache Hits: 3502
   Total Local Cache Hits: 8
   Total Memcache Hits:
   Memory Usage: 4096K
   Realpath Usage: 360K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3, all campuses, default day+boarding: 

   Page generation time: 3.66
   Total SQL Queries: 3953
   Total SQL Cache Hits: 24880
   Total Local Cache Hits: 195
   Total Memcache Hits:
   Memory Usage: 75776K
   Realpath Usage: 243K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3, all campuses, default day+boarding: 

   Page generation time: 0.197
   Total SQL Queries: 38
   Total SQL Cache Hits: 3501
   Total Local Cache Hits: 8
   Total Memcache Hits:
   Memory Usage: 8192K
   Realpath Usage: 310K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3, all campuses, day students only: 

   Page generation time: 3.365
   Total SQL Queries: 3417
   Total SQL Cache Hits: 25751
   Total Local Cache Hits: 162
   Total Memcache Hits:
   Memory Usage: 65536K
   Realpath Usage: 256K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3, all campuses, day students only: 

   Page generation time: 0.193
   Total SQL Queries: 39
   Total SQL Cache Hits: 3502
   Total Local Cache Hits: 8
   Total Memcache Hits:
   Memory Usage: 6144K
   Realpath Usage: 320K

RETURN

SDS Gavintech: Staff Menu -> Attendance -> Absent students

Staff Menu -> Attendance -> Absent students

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

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

   Page generation time: 9.085
   Total SQL Queries: 10262
   Total SQL Cache Hits: 21760
   Total Local Cache Hits: 5675
   Total Memcache Hits:
   Memory Usage: 180224K
   Realpath Usage: 194K

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

   Page generation time: 7.921
   Total SQL Queries: 9751
   Total SQL Cache Hits: 17131
   Total Local Cache Hits: 5670
   Total Memcache Hits:
   Memory Usage: 169984K
   Realpath Usage: 260K

RETURN

SDS Gavintech: Staff Menu -> Canned Reports -> Emergency Phone List

Staff Menu -> Canned Reports -> Emergency Phone List

https://sds.smus.ca/index.php?next_page=admin/students/emergency_phone_list.php

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

   Page generation time: 9.43
   Total SQL Queries: 11576
   Total SQL Cache Hits: 24286
   Total Local Cache Hits: 10
   Total Memcache Hits:
   Memory Usage: 215040K
   Realpath Usage: 217K

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

   Page generation time: 8.739
   Total SQL Queries: 11065
   Total SQL Cache Hits: 19658
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 206848K
   Realpath Usage: 239K

RETURN

SDS Gavintech: Staff Menu -> Canned Reports -> Admissions Accepts

Staff Menu -> Canned Reports -> Admissions Accepts

https://sds.smus.ca/index.php?next_page=admin/admission/accepts_interests.php

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3, default just picklist with blank option chosen: 

   Page generation time: 13.705
   Total SQL Queries: 15917
   Total SQL Cache Hits: 15212
   Total Local Cache Hits: 3069
   Total Memcache Hits:
   Memory Usage: 290816K
   Realpath Usage: 268K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3, default just picklist with blank option chosen: 

   Page generation time: 12.326
   Total SQL Queries: 15408
   Total SQL Cache Hits: 10584
   Total Local Cache Hits: 3066
   Total Memcache Hits:
   Memory Usage: 280576K
   Realpath Usage: 313K

Measured on Thu 2024 Aug 29, when as DRD, effective date Mon 2024 Jun 3, picklist option "Sports: Basketball" chosen: 

   Page generation time: 14.006
   Total SQL Queries: 15917
   Total SQL Cache Hits: 15212
   Total Local Cache Hits: 3070
   Total Memcache Hits:
   Memory Usage: 290816K
   Realpath Usage: 216K

Measured on Fri 2024 Sep 6, when as DRD, effective date Mon 2024 Jun 3, picklist option "Sports: Basketball" chosen: 

   Page generation time: 12.338
   Total SQL Queries: 15408
   Total SQL Cache Hits: 10584
   Total Local Cache Hits: 3067
   Total Memcache Hits:
   Memory Usage: 280576K
   Realpath Usage: 300K

RETURN

Retrieved from "https://wiki.smus.ca/index.php?title=SDSM:Performance_Measurements&oldid=27334"