SDSM:Performance Measurements: Difference between revisions

From SMUSwiki
Jump to navigation Jump to search
(Add measurements for a dozen more screens, plus some existing screens, before and after Release 10.1.0 of 2024 Oct 1.)
(Added measurements taken 2024 Dec 14 showing effects of changes in the 10.2.0 release.)
 
Line 65: Line 65:
* 2024 Sep 2 - Release 10.0.0 - main menu generation on all screens; Input Absences screen
* 2024 Sep 2 - Release 10.0.0 - main menu generation on all screens; Input Absences screen
* 2024 Oct 1 - Release 10.1.0 - all/most screens using lists of students
* 2024 Oct 1 - Release 10.1.0 - all/most screens using lists of students
* PENDING - Release 10.2.0 - all/most screens filtering lists of students to a campus
* 2024 Oct 28 - Release 10.2.0 - all/most screens filtering lists of students to a campus


[[#top|RETURN]]
[[#top|RETURN]]
Line 341: Line 341:
     Memory Usage: 45056K
     Memory Usage: 45056K
     Realpath Usage: 262K
     Realpath Usage: 262K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3:
    Page generation time: 1.575
    Total SQL Queries: 735
    Total SQL Cache Hits: 11913
    Total Local Cache Hits: 13366
    Total Memcache Hits:
    Memory Usage: 61440K
    Realpath Usage: 236K


[[#top|RETURN]]
[[#top|RETURN]]
Line 489: Line 499:
     Memory Usage: 153600K
     Memory Usage: 153600K
     Realpath Usage: 228K
     Realpath Usage: 228K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default for all filters:
    Page generation time: 0.789
    Total SQL Queries: 477
    Total SQL Cache Hits: 5272
    Total Local Cache Hits: 3892
    Total Memcache Hits:
    Memory Usage: 16384K
    Realpath Usage: 188K


[[#top|RETURN]]
[[#top|RETURN]]
Line 519: Line 540:
     Memory Usage: 30720K
     Memory Usage: 30720K
     Realpath Usage: 256K
     Realpath Usage: 256K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default for all filters:
    Page generation time: 1.472
    Total SQL Queries: 1474
    Total SQL Cache Hits: 6725
    Total Local Cache Hits: 2265
    Total Memcache Hits:
    Memory Usage: 34816K
    Realpath Usage: 22K


Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3,
Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3,
Line 541: Line 573:
     Memory Usage: 51200K
     Memory Usage: 51200K
     Realpath Usage: 293K
     Realpath Usage: 293K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
with "Additional Options: Day student", default for all other filters:
    Page generation time: 1.957
    Total SQL Queries: 991
    Total SQL Cache Hits: 4234
    Total Local Cache Hits: 5104
    Total Memcache Hits:
    Memory Usage: 63488K
    Realpath Usage: 229K


[[#top|RETURN]]
[[#top|RETURN]]
Line 593: Line 636:
     Memory Usage: 38912K
     Memory Usage: 38912K
     Realpath Usage: 189K
     Realpath Usage: 189K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default all students:
    Page generation time: 1.121
    Total SQL Queries: 59
    Total SQL Cache Hits: 3492
    Total Local Cache Hits: 17212
    Total Memcache Hits:
    Memory Usage: 49152K
    Realpath Usage: 235K


[[#top|RETURN]]
[[#top|RETURN]]
Line 645: Line 699:
     Memory Usage: 118784K
     Memory Usage: 118784K
     Realpath Usage: 262K
     Realpath Usage: 262K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default just picklist with blank option chosen:
    Page generation time: 5.568
    Total SQL Queries: 5270
    Total SQL Cache Hits: 10156
    Total Local Cache Hits: 3722
    Total Memcache Hits:
    Memory Usage: 141312K
    Realpath Usage: 211K


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 697: Line 762:
     Memory Usage: 301056K
     Memory Usage: 301056K
     Realpath Usage: 228K
     Realpath Usage: 228K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default all old+new students, default enrolled status only:
    Page generation time: 12.422
    Total SQL Queries: 14815
    Total SQL Cache Hits: 14576
    Total Local Cache Hits: 9531
    Total Memcache Hits:
    Memory Usage: 305152K
    Realpath Usage: 262K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 721: Line 797:
     Memory Usage: 1568468K
     Memory Usage: 1568468K
     Realpath Usage: 23K
     Realpath Usage: 23K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default all old+new students, all statuses;
production exhausts RAM and crashes so these are measurements are on sdsdev:
    Page generation time: N/A
    Total SQL Queries: 82272
    Total SQL Cache Hits: 70129
    Total Local Cache Hits: 46563
    Total Memcache Hits:
    Memory Usage: 1482240K
    Realpath Usage: 257K


[[#top|RETURN]]
[[#top|RETURN]]
Line 751: Line 839:
     Memory Usage: 12288K
     Memory Usage: 12288K
     Realpath Usage: 189K
     Realpath Usage: 189K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
initial screen conditions with no search performed:
    Page generation time: 0.132
    Total SQL Queries: 31
    Total SQL Cache Hits: 3491
    Total Local Cache Hits: 5
    Total Memcache Hits:
    Memory Usage: 36864K
    Realpath Usage: 229K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 773: Line 872:
     Memory Usage: 67584K
     Memory Usage: 67584K
     Realpath Usage: 228K
     Realpath Usage: 228K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
with filter "student.grade IN (Grade 12)":
    Page generation time: 3.749
    Total SQL Queries: 2601
    Total SQL Cache Hits: 8003
    Total Local Cache Hits: 3650
    Total Memcache Hits:
    Memory Usage: 90112K
    Realpath Usage: 233K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 795: Line 905:
     Memory Usage: 436224K
     Memory Usage: 436224K
     Realpath Usage: 221K
     Realpath Usage: 221K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
with filter "student.is_day_student = 'Y'":
    Page generation time: 24.196
    Total SQL Queries: 22289
    Total SQL Cache Hits: 43741
    Total Local Cache Hits: 42873
    Total Memcache Hits:
    Memory Usage: 436224K
    Realpath Usage: 23K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 817: Line 938:
     Memory Usage: 79872K
     Memory Usage: 79872K
     Realpath Usage: 189K
     Realpath Usage: 189K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
with filter "student.grade IN (Grade 12) AND student.is_day_student = 'Y'":
    Page generation time: 2.814
    Total SQL Queries: 1550
    Total SQL Cache Hits: 6295
    Total Local Cache Hits: 5207
    Total Memcache Hits:
    Memory Usage: 73728K
    Realpath Usage: 209K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 840: Line 972:
     Memory Usage: 1042944K
     Memory Usage: 1042944K
     Realpath Usage: 189K
     Realpath Usage: 189K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
with filter "student.sex = 'F'":
    Page generation time: 56.892
    Total SQL Queries: 54360
    Total SQL Cache Hits: 108399
    Total Local Cache Hits: 127929
    Total Memcache Hits:
    Memory Usage: 1000008K
    Realpath Usage: 296K


[[#top|RETURN]]
[[#top|RETURN]]
Line 870: Line 1,013:
     Memory Usage: 40960K
     Memory Usage: 40960K
     Realpath Usage: 285K
     Realpath Usage: 285K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default screen conditions where result Parent List is empty:
    Page generation time: 1.125
    Total SQL Queries: 71
    Total SQL Cache Hits: 3494
    Total Local Cache Hits: 5210
    Total Memcache Hits:
    Memory Usage: 49152K
    Realpath Usage: 230K


Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3,
Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3,
Line 894: Line 1,048:
     Memory Usage: 126976K
     Memory Usage: 126976K
     Realpath Usage: 197K
     Realpath Usage: 197K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default all students selected, default for all other filters,
Update Parent List button clicked:
    Page generation time: 71.517
    Total SQL Queries: 4945
    Total SQL Cache Hits: 5101
    Total Local Cache Hits: 8400
    Total Memcache Hits:
    Memory Usage: 135168K
    Realpath Usage: 234K


[[#top|RETURN]]
[[#top|RETURN]]
Line 924: Line 1,090:
     Memory Usage: 149504K
     Memory Usage: 149504K
     Realpath Usage: 233K
     Realpath Usage: 233K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
senior campus only:
    Page generation time: 0.756
    Total SQL Queries: 119
    Total SQL Cache Hits: 5017
    Total Local Cache Hits: 6828
    Total Memcache Hits:
    Memory Usage: 34816K
    Realpath Usage: 230K


[[#top|RETURN]]
[[#top|RETURN]]
Line 954: Line 1,131:
     Memory Usage: 92160K
     Memory Usage: 92160K
     Realpath Usage: 235K
     Realpath Usage: 235K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default all campuses, default all other filters:
    Page generation time: 4.508
    Total SQL Queries: 3805
    Total SQL Cache Hits: 10948
    Total Local Cache Hits: 3555
    Total Memcache Hits:
    Memory Usage: 112640K
    Realpath Usage: 295K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 976: Line 1,164:
     Memory Usage: 397312K
     Memory Usage: 397312K
     Realpath Usage: 284K
     Realpath Usage: 284K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
senior campus only, default all other filters:
    Page generation time: 19.435
    Total SQL Queries: 22018
    Total SQL Cache Hits: 7561
    Total Local Cache Hits: 1939
    Total Memcache Hits:
    Memory Usage: 423936K
    Realpath Usage: 229K


[[#top|RETURN]]
[[#top|RETURN]]
Line 1,008: Line 1,207:
     Memory Usage: 161792K
     Memory Usage: 161792K
     Realpath Usage: 260K
     Realpath Usage: 260K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default senior campus only,
but page title is "Senior School Funnel for 03 September, 2024":
    Page generation time: 7.878
    Total SQL Queries: 7621
    Total SQL Cache Hits: 14378
    Total Local Cache Hits: 9393
    Total Memcache Hits:
    Memory Usage: 178176K
    Realpath Usage: 223K


[[#top|RETURN]]
[[#top|RETURN]]
Line 1,036: Line 1,247:
     Memory Usage: 225280K
     Memory Usage: 225280K
     Realpath Usage: 233K
     Realpath Usage: 233K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3:
    Page generation time: 3.909
    Total SQL Queries: 4912
    Total SQL Cache Hits: 8783
    Total Local Cache Hits: 6784
    Total Memcache Hits:
    Memory Usage: 98304K
    Realpath Usage: 23K


[[#top|RETURN]]
[[#top|RETURN]]
Line 1,068: Line 1,289:
     Memory Usage: 38912K
     Memory Usage: 38912K
     Realpath Usage: 244K
     Realpath Usage: 244K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default senior campus only, default all grades "9,10,11,12", all subjects,
Change button clicked:
    Page generation time: 1.703
    Total SQL Queries: 772
    Total SQL Cache Hits: 5444
    Total Local Cache Hits: 2783
    Total Memcache Hits:
    Memory Usage: 63488K
    Realpath Usage: 208K


Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3,
Line 1,094: Line 1,327:
     Memory Usage: 24576K
     Memory Usage: 24576K
     Realpath Usage: 280K
     Realpath Usage: 280K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default senior campus only, grade 9 only,
subjects "Academic Advising (Grade 9)" plus "Academic Report (Grade 9)" only,
Change button clicked:
    Page generation time: 0.992
    Total SQL Queries: 65
    Total SQL Cache Hits: 3505
    Total Local Cache Hits: 124
    Total Memcache Hits:
    Memory Usage: 49152K
    Realpath Usage: 294K


[[#top|RETURN]]
[[#top|RETURN]]
Line 1,124: Line 1,370:
     Memory Usage: 264192K
     Memory Usage: 264192K
     Realpath Usage: 284K
     Realpath Usage: 284K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
default for all filters:
    Page generation time: 10.814
    Total SQL Queries: 12672
    Total SQL Cache Hits: 46127
    Total Local Cache Hits: 14578
    Total Memcache Hits:
    Memory Usage: 272384K
    Realpath Usage: 213K


[[#top|RETURN]]
[[#top|RETURN]]
Line 1,156: Line 1,413:
     Memory Usage: 184320K
     Memory Usage: 184320K
     Realpath Usage: 206K
     Realpath Usage: 206K
Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3,
honor roll factor filter mark caption is "TRAX MCP: AP Mark",
default for all other honor roll factor filters:
    Page generation time: 5.453
    Total SQL Queries: 2186
    Total SQL Cache Hits: 10518
    Total Local Cache Hits: 8776
    Total Memcache Hits:
    Memory Usage: 47104K
    Realpath Usage: 232K


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

Latest revision as of 01:31, 16 December 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.

These are the important transition dates, when a new version of SDS was released to production that would have affected its measured performance:

  • 2024 Sep 2 - Release 10.0.0 - main menu generation on all screens; Input Absences screen
  • 2024 Oct 1 - Release 10.1.0 - all/most screens using lists of students
  • 2024 Oct 28 - Release 10.2.0 - all/most screens filtering lists of students to a campus

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

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3: 

   Page generation time: 9.465
   Total SQL Queries: 11366
   Total SQL Cache Hits: 25570
   Total Local Cache Hits: 227
   Total Memcache Hits:
   Memory Usage: 208896K
   Realpath Usage: 282K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3: 

   Page generation time: 1.866
   Total SQL Queries: 1395
   Total SQL Cache Hits: 23361
   Total Local Cache Hits: 2050
   Total Memcache Hits:
   Memory Usage: 45056K
   Realpath Usage: 262K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3: 

   Page generation time: 1.575
   Total SQL Queries: 735
   Total SQL Cache Hits: 11913
   Total Local Cache Hits: 13366
   Total Memcache Hits:
   Memory Usage: 61440K
   Realpath Usage: 236K

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

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

   Page generation time: 8.006
   Total SQL Queries: 9751
   Total SQL Cache Hits: 17131
   Total Local Cache Hits: 5670
   Total Memcache Hits:
   Memory Usage: 172032K
   Realpath Usage: 299K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default for all filters: 

   Page generation time: 7.05
   Total SQL Queries: 8713
   Total SQL Cache Hits: 11716
   Total Local Cache Hits: 9935
   Total Memcache Hits:
   Memory Usage: 153600K
   Realpath Usage: 228K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default for all filters: 

   Page generation time: 0.789
   Total SQL Queries: 477
   Total SQL Cache Hits: 5272
   Total Local Cache Hits: 3892
   Total Memcache Hits:
   Memory Usage: 16384K
   Realpath Usage: 188K

RETURN

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

Staff Menu -> Attendance -> Unexplained absences

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

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

   Page generation time: 2.197
   Total SQL Queries: 2453
   Total SQL Cache Hits: 6782
   Total Local Cache Hits: 2265
   Total Memcache Hits:
   Memory Usage: 53248K
   Realpath Usage: 359K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default for all filters: 

   Page generation time: 1.494
   Total SQL Queries: 1472
   Total SQL Cache Hits: 6725
   Total Local Cache Hits: 2265
   Total Memcache Hits:
   Memory Usage: 30720K
   Realpath Usage: 256K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default for all filters: 

   Page generation time: 1.472
   Total SQL Queries: 1474
   Total SQL Cache Hits: 6725
   Total Local Cache Hits: 2265
   Total Memcache Hits:
   Memory Usage: 34816K
   Realpath Usage: 22K

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3, with "Additional Options: Day student", default for all other filters: 

   Page generation time: 9.238
   Total SQL Queries: 10997
   Total SQL Cache Hits: 8246
   Total Local Cache Hits: 1506
   Total Memcache Hits:
   Memory Usage: 204800K
   Realpath Usage: 261K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, with "Additional Options: Day student", default for all other filters: 

   Page generation time: 1.697
   Total SQL Queries: 1020
   Total SQL Cache Hits: 4936
   Total Local Cache Hits: 4599
   Total Memcache Hits:
   Memory Usage: 51200K
   Realpath Usage: 293K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, with "Additional Options: Day student", default for all other filters: 

   Page generation time: 1.957
   Total SQL Queries: 991
   Total SQL Cache Hits: 4234
   Total Local Cache Hits: 5104
   Total Memcache Hits:
   Memory Usage: 63488K
   Realpath Usage: 229K

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

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

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

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default all students: 

   Page generation time: 1.701
   Total SQL Queries: 1088
   Total SQL Cache Hits: 17576
   Total Local Cache Hits: 2087
   Total Memcache Hits:
   Memory Usage: 38912K
   Realpath Usage: 189K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default all students: 

   Page generation time: 1.121
   Total SQL Queries: 59
   Total SQL Cache Hits: 3492
   Total Local Cache Hits: 17212
   Total Memcache Hits:
   Memory Usage: 49152K
   Realpath Usage: 235K

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 Sep 26, when as DRD, effective date Mon 2024 Jun 3, default just picklist with blank option chosen: 

   Page generation time: 13.125
   Total SQL Queries: 15438
   Total SQL Cache Hits: 10569
   Total Local Cache Hits: 3091
   Total Memcache Hits:
   Memory Usage: 282624K
   Realpath Usage: 230K

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

   Page generation time: 5.429
   Total SQL Queries: 5462
   Total SQL Cache Hits: 10358
   Total Local Cache Hits: 3303
   Total Memcache Hits:
   Memory Usage: 118784K
   Realpath Usage: 262K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default just picklist with blank option chosen: 

   Page generation time: 5.568
   Total SQL Queries: 5270
   Total SQL Cache Hits: 10156
   Total Local Cache Hits: 3722
   Total Memcache Hits:
   Memory Usage: 141312K
   Realpath Usage: 211K

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

SDS Gavintech: Staff Menu -> Canned Reports -> Day Market Report

Staff Menu -> Canned Reports -> Day Market Report

https://sds.smus.ca/index.php?next_page=admin/parents/day_market_report.php

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, default all old+new students, default enrolled status only: 

   Page generation time: 21.025
   Total SQL Queries: 26057
   Total SQL Cache Hits: 19771
   Total Local Cache Hits: 2827
   Total Memcache Hits:
   Memory Usage: 464896K
   Realpath Usage: 280K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default all old+new students, default enrolled status only: 

   Page generation time: 13.022
   Total SQL Queries: 16086
   Total SQL Cache Hits: 15970
   Total Local Cache Hits: 6638
   Total Memcache Hits:
   Memory Usage: 301056K
   Realpath Usage: 228K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default all old+new students, default enrolled status only: 

   Page generation time: 12.422
   Total SQL Queries: 14815
   Total SQL Cache Hits: 14576
   Total Local Cache Hits: 9531
   Total Memcache Hits:
   Memory Usage: 305152K
   Realpath Usage: 262K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, default all old+new students, all statuses; production exhausts RAM and crashes so these are measurements are on sdsdev: 

   Page generation time: N/A
   Total SQL Queries: 99155
   Total SQL Cache Hits: 100611
   Total Local Cache Hits: 15445
   Total Memcache Hits:
   Memory Usage: 1751516K
   Realpath Usage: 272K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default all old+new students, all statuses; production exhausts RAM and crashes so these are measurements are on sdsdev: 

   Page generation time: N/A
   Total SQL Queries: 88987
   Total SQL Cache Hits: 77737
   Total Local Cache Hits: 30763
   Total Memcache Hits:
   Memory Usage: 1568468K
   Realpath Usage: 23K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default all old+new students, all statuses; production exhausts RAM and crashes so these are measurements are on sdsdev: 

   Page generation time: N/A
   Total SQL Queries: 82272
   Total SQL Cache Hits: 70129
   Total Local Cache Hits: 46563
   Total Memcache Hits:
   Memory Usage: 1482240K
   Realpath Usage: 257K

RETURN

SDS Gavintech: Staff Menu -> Advanced search

Staff Menu -> Advanced search

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

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, initial screen conditions with no search performed: 

   Page generation time: 0.125
   Total SQL Queries: 30
   Total SQL Cache Hits: 3491
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 18432K
   Realpath Usage: 254K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, initial screen conditions with no search performed: 

   Page generation time: 0.137
   Total SQL Queries: 31
   Total SQL Cache Hits: 3491
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 12288K
   Realpath Usage: 189K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, initial screen conditions with no search performed: 

   Page generation time: 0.132
   Total SQL Queries: 31
   Total SQL Cache Hits: 3491
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 36864K
   Realpath Usage: 229K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, with filter "student.grade IN (Grade 12)": 

   Page generation time: 11.967
   Total SQL Queries: 12730
   Total SQL Cache Hits: 10024
   Total Local Cache Hits: 1465
   Total Memcache Hits:
   Memory Usage: 233472K
   Realpath Usage: 293K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.grade IN (Grade 12)": 

   Page generation time: 3.596
   Total SQL Queries: 2753
   Total SQL Cache Hits: 9698
   Total Local Cache Hits: 1791
   Total Memcache Hits:
   Memory Usage: 67584K
   Realpath Usage: 228K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.grade IN (Grade 12)": 

   Page generation time: 3.749
   Total SQL Queries: 2601
   Total SQL Cache Hits: 8003
   Total Local Cache Hits: 3650
   Total Memcache Hits:
   Memory Usage: 90112K
   Realpath Usage: 233K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, with filter "student.is_day_student = 'Y'": 

   Page generation time: 31.991
   Total SQL Queries: 33824
   Total SQL Cache Hits: 72526
   Total Local Cache Hits: 12518
   Total Memcache Hits:
   Memory Usage: 604672K
   Realpath Usage: 305K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.is_day_student = 'Y'": 

   Page generation time: 24.495
   Total SQL Queries: 23862
   Total SQL Cache Hits: 69439
   Total Local Cache Hits: 15655
   Total Memcache Hits:
   Memory Usage: 436224K
   Realpath Usage: 221K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.is_day_student = 'Y'": 

   Page generation time: 24.196
   Total SQL Queries: 22289
   Total SQL Cache Hits: 43741
   Total Local Cache Hits: 42873
   Total Memcache Hits:
   Memory Usage: 436224K
   Realpath Usage: 23K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, with filter "student.grade IN (Grade 12) AND student.is_day_student = 'Y'": 

   Page generation time: 10.163
   Total SQL Queries: 11617
   Total SQL Cache Hits: 7680
   Total Local Cache Hits: 918
   Total Memcache Hits:
   Memory Usage: 212992K
   Realpath Usage: 266K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.grade IN (Grade 12) AND student.is_day_student = 'Y'": 

   Page generation time: 2.461
   Total SQL Queries: 1640
   Total SQL Cache Hits: 7152
   Total Local Cache Hits: 4250
   Total Memcache Hits:
   Memory Usage: 79872K
   Realpath Usage: 189K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.grade IN (Grade 12) AND student.is_day_student = 'Y'": 

   Page generation time: 2.814
   Total SQL Queries: 1550
   Total SQL Cache Hits: 6295
   Total Local Cache Hits: 5207
   Total Memcache Hits:
   Memory Usage: 73728K
   Realpath Usage: 209K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, with filter "student.sex = 'F'"; production exhausts RAM and crashes so these are measurements are on sdsdev: 

   Page generation time: N/A
   Total SQL Queries: 68729
   Total SQL Cache Hits: 213101
   Total Local Cache Hits: 28558
   Total Memcache Hits:
   Memory Usage: 1215544K
   Realpath Usage: 275K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.sex = 'F'": 

   Page generation time: 59.732
   Total SQL Queries: 58542
   Total SQL Cache Hits: 191474
   Total Local Cache Hits: 37471
   Total Memcache Hits:
   Memory Usage: 1042944K
   Realpath Usage: 189K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, with filter "student.sex = 'F'": 

   Page generation time: 56.892
   Total SQL Queries: 54360
   Total SQL Cache Hits: 108399
   Total Local Cache Hits: 127929
   Total Memcache Hits:
   Memory Usage: 1000008K
   Realpath Usage: 296K

RETURN

SDS Gavintech: Staff menu -> Email -> Email parents

Staff menu -> Email -> Email parents

https://sds.smus.ca/index.php?next_page=email/email_parents.php&reset=true

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3, default screen conditions where result Parent list is empty: 

   Page generation time: 9.026
   Total SQL Queries: 11077
   Total SQL Cache Hits: 6617
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 206848K
   Realpath Usage: 268K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default screen conditions where result Parent List is empty: 

   Page generation time: 1.496
   Total SQL Queries: 1100
   Total SQL Cache Hits: 3494
   Total Local Cache Hits: 3128
   Total Memcache Hits:
   Memory Usage: 40960K
   Realpath Usage: 285K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default screen conditions where result Parent List is empty: 

   Page generation time: 1.125
   Total SQL Queries: 71
   Total SQL Cache Hits: 3494
   Total Local Cache Hits: 5210
   Total Memcache Hits:
   Memory Usage: 49152K
   Realpath Usage: 230K

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3, default all students selected, default for all other filters, Update Parent List button clicked: 

   Page generation time: 77.474
   Total SQL Queries: 15846
   Total SQL Cache Hits: 12343
   Total Local Cache Hits: 5
   Total Memcache Hits:
   Memory Usage: 290816K
   Realpath Usage: 267K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default all students selected, default for all other filters, Update Parent List button clicked: 

   Page generation time: 73.321
   Total SQL Queries: 5987
   Total SQL Cache Hits: 9293
   Total Local Cache Hits: 3154
   Total Memcache Hits:
   Memory Usage: 126976K
   Realpath Usage: 197K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default all students selected, default for all other filters, Update Parent List button clicked: 

   Page generation time: 71.517
   Total SQL Queries: 4945
   Total SQL Cache Hits: 5101
   Total Local Cache Hits: 8400
   Total Memcache Hits:
   Memory Usage: 135168K
   Realpath Usage: 234K

RETURN

SDS Gavintech: Admin Menu -> Admissions -> Enrolment Summary

Admin Menu -> Admissions -> Enrolment Summary

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

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3, senior campus only: 

   Page generation time: 8.227
   Total SQL Queries: 9486
   Total SQL Cache Hits: 20100
   Total Local Cache Hits: 5273
   Total Memcache Hits:
   Memory Usage: 165888K
   Realpath Usage: 290K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, senior campus only: 

   Page generation time: 6.893
   Total SQL Queries: 8448
   Total SQL Cache Hits: 11259
   Total Local Cache Hits: 13073
   Total Memcache Hits:
   Memory Usage: 149504K
   Realpath Usage: 233K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, senior campus only: 

   Page generation time: 0.756
   Total SQL Queries: 119
   Total SQL Cache Hits: 5017
   Total Local Cache Hits: 6828
   Total Memcache Hits:
   Memory Usage: 34816K
   Realpath Usage: 230K

RETURN

SDS Gavintech: Admin Menu -> Admissions -> Accepts/Offers

Admin Menu -> Admissions -> Accepts/Offers

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

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, default all campuses, default all other filters: 

   Page generation time: 11.551
   Total SQL Queries: 13954
   Total SQL Cache Hits: 11528
   Total Local Cache Hits: 2714
   Total Memcache Hits:
   Memory Usage: 253952K
   Realpath Usage: 263K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default all campuses, default all other filters: 

   Page generation time: 4.282
   Total SQL Queries: 3996
   Total SQL Cache Hits: 11360
   Total Local Cache Hits: 2934
   Total Memcache Hits:
   Memory Usage: 92160K
   Realpath Usage: 235K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default all campuses, default all other filters: 

   Page generation time: 4.508
   Total SQL Queries: 3805
   Total SQL Cache Hits: 10948
   Total Local Cache Hits: 3555
   Total Memcache Hits:
   Memory Usage: 112640K
   Realpath Usage: 295K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, senior campus only, default all other filters: 

   Page generation time: 27.848
   Total SQL Queries: 31966
   Total SQL Cache Hits: 8124
   Total Local Cache Hits: 1487
   Total Memcache Hits:
   Memory Usage: 561152K
   Realpath Usage: 268K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, senior campus only, default all other filters: 

   Page generation time: 19.857
   Total SQL Queries: 21993
   Total SQL Cache Hits: 7785
   Total Local Cache Hits: 1600
   Total Memcache Hits:
   Memory Usage: 397312K
   Realpath Usage: 284K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, senior campus only, default all other filters: 

   Page generation time: 19.435
   Total SQL Queries: 22018
   Total SQL Cache Hits: 7561
   Total Local Cache Hits: 1939
   Total Memcache Hits:
   Memory Usage: 423936K
   Realpath Usage: 229K

RETURN

SDS Gavintech: Admin Menu -> Admissions -> Student Funnel

Admin Menu -> Admissions -> Student Funnel

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

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, but page title is "Senior School Funnel for 03 September, 2024": 

   Page generation time: 16.129
   Total SQL Queries: 18179
   Total SQL Cache Hits: 18920
   Total Local Cache Hits: 4268
   Total Memcache Hits:
   Memory Usage: 327680K
   Realpath Usage: 221K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, but page title is "Senior School Funnel for 03 September, 2024": 

   Page generation time: 7.978
   Total SQL Queries: 8200
   Total SQL Cache Hits: 14977
   Total Local Cache Hits: 8209
   Total Memcache Hits:
   Memory Usage: 161792K
   Realpath Usage: 260K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, but page title is "Senior School Funnel for 03 September, 2024": 

   Page generation time: 7.878
   Total SQL Queries: 7621
   Total SQL Cache Hits: 14378
   Total Local Cache Hits: 9393
   Total Memcache Hits:
   Memory Usage: 178176K
   Realpath Usage: 223K

RETURN

SDS Gavintech: Admin Menu -> Finance -> ES Audit Report -> Daily Attendance

Admin Menu -> Finance -> ES Audit Report -> Daily Attendance

https://sds.smus.ca/index.php?next_page=admin/finance/es_daily.php

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3: 

   Page generation time: 10.524
   Total SQL Queries: 13718
   Total SQL Cache Hits: 23921
   Total Local Cache Hits: 5840
   Total Memcache Hits:
   Memory Usage: 243712K
   Realpath Usage: 230K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3: 

   Page generation time: 9.507
   Total SQL Queries: 12675
   Total SQL Cache Hits: 18087
   Total Local Cache Hits: 10022
   Total Memcache Hits:
   Memory Usage: 225280K
   Realpath Usage: 233K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3: 

   Page generation time: 3.909
   Total SQL Queries: 4912
   Total SQL Cache Hits: 8783
   Total Local Cache Hits: 6784
   Total Memcache Hits:
   Memory Usage: 98304K
   Realpath Usage: 23K

RETURN

SDS Gavintech: Admin Menu -> Pre-selection -> Conflict Matrix

Admin Menu -> Pre-selection -> Conflict Matrix

https://sds.smus.ca/index.php?next_page=admin/preregistration/conflict_matrix.php

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, default all grades "9,10,11,12", all subjects, Change button clicked: 

   Page generation time: 8.873
   Total SQL Queries: 10731
   Total SQL Cache Hits: 6301
   Total Local Cache Hits: 2382
   Total Memcache Hits:
   Memory Usage: 202752K
   Realpath Usage: 305K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, default all grades "9,10,11,12", all subjects, Change button clicked: 

   Page generation time: 1.246
   Total SQL Queries: 754
   Total SQL Cache Hits: 5708
   Total Local Cache Hits: 2975
   Total Memcache Hits:
   Memory Usage: 38912K
   Realpath Usage: 244K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, default all grades "9,10,11,12", all subjects, Change button clicked: 

   Page generation time: 1.703
   Total SQL Queries: 772
   Total SQL Cache Hits: 5444
   Total Local Cache Hits: 2783
   Total Memcache Hits:
   Memory Usage: 63488K
   Realpath Usage: 208K

Measured on Fri 2024 Sep 27, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, grade 9 only, subjects "Academic Advising (Grade 9)" plus "Academic Report (Grade 9)" only, Change button clicked: 

   Page generation time: 8.15
   Total SQL Queries: 10030
   Total SQL Cache Hits: 4098
   Total Local Cache Hits: 7
   Total Memcache Hits:
   Memory Usage: 186368K
   Realpath Usage: 260K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, grade 9 only, subjects "Academic Advising (Grade 9)" plus "Academic Report (Grade 9)" only, Change button clicked: 

   Page generation time: 0.734
   Total SQL Queries: 53
   Total SQL Cache Hits: 3505
   Total Local Cache Hits: 124
   Total Memcache Hits:
   Memory Usage: 24576K
   Realpath Usage: 280K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default senior campus only, grade 9 only, subjects "Academic Advising (Grade 9)" plus "Academic Report (Grade 9)" only, Change button clicked: 

   Page generation time: 0.992
   Total SQL Queries: 65
   Total SQL Cache Hits: 3505
   Total Local Cache Hits: 124
   Total Memcache Hits:
   Memory Usage: 49152K
   Realpath Usage: 294K

RETURN

SDS Gavintech: Admin Menu -> Students -> List Students

Admin Menu -> Students -> List Students

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

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

   Page generation time: 19.541
   Total SQL Queries: 23647
   Total SQL Cache Hits: 53177
   Total Local Cache Hits: 9337
   Total Memcache Hits:
   Memory Usage: 430080K
   Realpath Usage: 280K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, default for all filters: 

   Page generation time: 12.873
   Total SQL Queries: 13701
   Total SQL Cache Hits: 48209
   Total Local Cache Hits: 11455
   Total Memcache Hits:
   Memory Usage: 264192K
   Realpath Usage: 284K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, default for all filters: 

   Page generation time: 10.814
   Total SQL Queries: 12672
   Total SQL Cache Hits: 46127
   Total Local Cache Hits: 14578
   Total Memcache Hits:
   Memory Usage: 272384K
   Realpath Usage: 213K

RETURN

SDS Gavintech: Admin Menu -> Awards -> Award recommendations

Admin Menu -> Awards -> Award recommendations

https://sds.smus.ca/index.php?next_page=admin/awards/award_recommendations.php

Measured on Thu 2024 Sep 26, when as DRD, effective date Mon 2024 Jun 3, honor roll factor filter mark caption is "TRAX MCP: AP Mark", default for all other honor roll factor filters: 

   Page generation time: 12.611
   Total SQL Queries: 11386
   Total SQL Cache Hits: 22454
   Total Local Cache Hits: 10531
   Total Memcache Hits:
   Memory Usage: 200704K
   Realpath Usage: 221K

Measured on Mon 2024 Oct 14, when as DRD, effective date Mon 2024 Jun 3, honor roll factor filter mark caption is "TRAX MCP: AP Mark", default for all other honor roll factor filters: 

   Page generation time: 11.615
   Total SQL Queries: 10348
   Total SQL Cache Hits: 16923
   Total Local Cache Hits: 14858
   Total Memcache Hits:
   Memory Usage: 184320K
   Realpath Usage: 206K

Measured on Sat 2024 Dec 14, when as DRD, effective date Mon 2024 Jun 3, honor roll factor filter mark caption is "TRAX MCP: AP Mark", default for all other honor roll factor filters: 

   Page generation time: 5.453
   Total SQL Queries: 2186
   Total SQL Cache Hits: 10518
   Total Local Cache Hits: 8776
   Total Memcache Hits:
   Memory Usage: 47104K
   Realpath Usage: 232K

RETURN

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