What happens when you run this with the OPTIMIZE command?
Simon
-----Original Message-----
From: Hise, Jeremy [mailto:[EMAIL PROTECTED]]
Sent: 14 June 2001 17:03
To: Mysql (E-mail)
Subject: Crazy Query
Hi:
We have a set-up that consists of mySQL running on Linux (rh6.2) with
Crystal Reports running reports on another machine. Everytime the report is
ran and CR grabs it's data through the query listed below, it ties up mySQL
(top reports processor % used is 90%+) and never seems to end. We've even
added a limit 50 on the end with no success.
Now, I look at posting my query as the same as someone posting code and
asking others to debug it. But I don't know what else to do at this point.
The query is pretty clean, as you can see. Any ideas?
Thanks!!!!
SELECT DISTINCT
bid_journal1.time, bid_journal1.ugroup, bid_journal1.type,
bid1.id, bid1.status, bid1.int_1_time_1, bid1.int_2_time_1,
bid1.int_3_time_1, bid1.no_show, bid1.offered_rate, bid1.offered_salary,
bid1.settled_rate, bid1.settled_salary,
job1.id, job1.title, job1.rate,
agency1.time, agency1.rank, agency1.name,
agency_location1.capability, agency_location1.location,
agency_location1.type,
job_admin_releases1.id,
job_releases1.id,
job_agency_releases1.job_release_id
FROM
bid_journal bid_journal1,
bid bid1,
job job1,
agency agency1,
agency_location agency_location1,
job_admin_releases job_admin_releases1,
job_releases job_releases1,
job_agency_releases job_agency_releases1
WHERE
bid_journal1.bid_id = bid1.id AND
bid1.job_id = job1.id AND
bid1.agency_id = agency1.id AND
agency1.id = agency_location1.agency_id AND
job1.id = job_admin_releases1.job_id AND
job_admin_releases1.id = job_releases1.job_admin_release_id AND
job_releases1.id = job_agency_releases1.job_release_id
ORDER BY
agency1.name ASC,
job1.id ASC,
bid1.id ASC
Jeremy
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
