Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
Solved
Optimizing a MySQL query created with Navicat GUI
Posted on 2011-03-07
Using the Navicat for MySQL query gui, I made this
SELECT SS_Student_Schedules.Id AS StudentID, SS_Student_Schedules.Class
It pulls the correct data, but it is extremely slow. Is there anything I can do to optimize it? Thank you!
SELECT SS_Student_Schedules.Id AS StudentID, SS_Student_Schedules.Class
It pulls the correct data, but it is extremely slow. Is there anything I can do to optimize it? Thank you!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
To optimize query we need the structure of the involved tables. Did you try EXPLAIN to identify the bottlenecks?
Some basic rules to optimize a query
1. Avoid temporary tables
2. INDEX columns which are being used in WHERE and in JOIN
3. Select only those columns which are required
Google to find other query optimization tips.
Some basic rules to optimize a query
1. Avoid temporary tables
2. INDEX columns which are being used in WHERE and in JOIN
3. Select only those columns which are required
Google to find other query optimization tips.
Active 4 days ago
Can you try this?
SELECT SS_Student_Schedules.Id AS StudentID,
SS_Student_Schedules.ClassCode AS CourseID,
SS_Class_Master_Local.Period_1 AS Period,
SS_Class_Master_Local.Sect AS Section
FROM SS_Student_Schedules
INNER JOIN SS_Class_Master_Local
ON SS_Student_Schedules.ClassSect = SS_Class_Master_Local.Sect
AND SS_Student_Schedules.ClassCode = SS_Class_Master_Local.Class
AND SS_Student_Schedules.Schl = SS_Class_Master_Local.School
INNER JOIN DG_Student_Master
ON SS_Student_Schedules.Id = DG_Student_Master.StudId
WHERE DG_Student_Master.CurStatus IN ('C','R','O')
Thank you, I will check on these items in the a.m. when I get to work. It already sheds some light since I am importing from an ODBC connection from COBOL into MySQL via Navicat. No keys are made, so I suspect I will have to add them. Stay tuned, and thanks again.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
- Server Hardware
- IT Administration
- Disaster Recovery
- Storage Software
- Databases
- Storage Hardware, MySQL Server, Hardware, Percona, *Backups
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month9 days, 1 hour left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.