As a District Administrator, you determine the query run-time settings that best suit your district, including how long a query takes to run and the average execution times that determine whether a query is a Light or Medium query [>>]. Based on these settings, PowerSchool SMS gathers statistics while the query is running that determine the effect the query has on system performance. PowerSchool SMS then displays the query's system load [>>] to users [Figure 42]. A query's system load provides an indicator as to whether it is appropriate to run the query during periods of normal system usage [see Query system load definitions and descriptions: >>].
Other configurable query run-time settings include restrictions that prevent queries from running at certain times of the day (such as when users are most active in the system), the number of days that query results are kept before a re-run of the query is required, the maximum number of Medium and Heavy queries that can be queued at one time, and whether to log all query transactions or only transaction errors.
|
=
|
Light: No effect on system performance while running. Users can run a Light query at any time. |
|
=
|
Medium: System performance is slowed slightly while the query is running but this does not negatively affect users. Typically, users can run a medium query any time. Note: Until a query is run and PowerSchool SMS has gathered statistics, the query is treated as a Medium query. |
|
=
|
Heavy: Significantly slows system performance while it is running. Users should run a Heavy query during low system usage times or only when the data is required immediately. |
