Skip to content
This repository has been archived by the owner on Nov 27, 2021. It is now read-only.

Slow Script #61

Open
rdok opened this issue Jan 26, 2015 · 0 comments
Open

Slow Script #61

rdok opened this issue Jan 26, 2015 · 0 comments

Comments

@rdok
Copy link
Member

rdok commented Jan 26, 2015

Script: public_html/app/views/partials/user/all-table-data-view.html.php
Problem: The above script is called in a loop from public_html/app/staff/index.php!!
The problem is all-table-data-vew.html.php has 2 queries. Which means if there are 30 tutors, there will be in total 60 sql queries 👎

TODO: Modify the above srcipts:
Retrieve all working hours & current teaching course in 2 quries. Use php to access this data

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant