Yes. I actually forgot to specify that. We thought maybe the ODBC/CR was
causing some overhead problems. So we did go straight to the monitor. But we
got the same problem.
-----Original Message-----
From: Huntress Gary B NPRI [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 12:12 PM
To: 'Hise, Jeremy'
Subject: RE: Crazy Query
The first thing I would do is open the mysql client on the redhat box and
try to run this query directly. Have you tried that?
Regards,
Gary Huntress
Code 4113
Naval Undersea Warfare Center
Newport, RI 02841
1-800-669-6892 x28990
-----Original Message-----
From: Hise, Jeremy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 12:03 PM
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
