Unanswered: slow query takes 10 min or none
i have to ask you guys about this problem...my frontend is php and my database is mysql...
in my php i have a very simple query...
TIMEDIFF(scan_log.Time_End,scan_log.Time_Start) AS 'Time Consumed', scan_log.Records,
scan_log INNER JOIN batch_log ON (scan_log.Job_No = batch_log.Job_Number)
INNER JOIN user ON (scan_log.Last_Name = user.Last_Name)
when this query is executed in my php page...it takes very long to displayed the result and sometimes it hangs...
do i need to make adjustments with my database?tables?
what should i do to make my query execute faster?
Take Nothing But Pictures;
Leave Nothing But Footprints;
Kill Nothing But Time;