{"id":728,"date":"2004-10-10T02:08:00","date_gmt":"2004-10-09T19:08:00","guid":{"rendered":"http:\/\/project-ile.net\/lulu\/confessions\/?p=11"},"modified":"2004-10-10T02:08:00","modified_gmt":"2004-10-09T19:08:00","slug":"11","status":"publish","type":"post","link":"https:\/\/project-ile.net\/lulu\/blog\/2004\/10\/10\/11\/","title":{"rendered":""},"content":{"rendered":"

After hour after hour of optimising, I’m giving up. Now we have this<\/p>\n

\n

SELECT count(enrollment_status) as student_count, enrollment_status,
\n
section.section_id, section.section_code, subject.subject_code, subject_name
\n
FROM enrollment left join section using (section_id) left join subject using
\n
(subject_code) left join section_instructor on section.section_id =
\n
section_instructor.section_id where
\n
section_instructor.instructor_id=’$instructor_id’ GROUP BY enrollment_status,
\n
section_id ORDER BY section_id , enrollment_status<\/p>\n<\/blockquote>\n

And it’s ALL * eq_ref * eq_ref * ALL relationship, with 60millions row combintion to search, plus a couple temp-table. I may have to consider re-arranging the table layout. The probelm is, the requirement that never be sattled before the project’s started. So, I’m giving up and will spend some more time in the not so close future to re-arrange them. -_-”’<\/p>\n","protected":false},"excerpt":{"rendered":"

After hour after hour of optimising, I’m giving up. Now we have this SELECT count(enrollment_status) as student_count, enrollment_status, section.section_id, section.section_code, subject.subject_code, subject_name FROM enrollment left join section using (section_id) left join subject using (subject_code) left join section_instructor on section.section_id = section_instructor.section_id where section_instructor.instructor_id=’$instructor_id’ GROUP BY enrollment_status, section_id ORDER BY section_id , enrollment_status And it’s ALL […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-728","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s3RSgi-11","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/posts\/728"}],"collection":[{"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/comments?post=728"}],"version-history":[{"count":0,"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/posts\/728\/revisions"}],"wp:attachment":[{"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/media?parent=728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/categories?post=728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/project-ile.net\/lulu\/blog\/wp-json\/wp\/v2\/tags?post=728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}