RE: Crazy Query

2001-06-14 Thread Hise, Jeremy
PM To: Mysql (E-mail) Subject: RE: Crazy Query 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]]

RE: Crazy Query

2001-06-14 Thread Hise, Jeremy
: '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 -Origin

RE: Crazy Query

2001-06-14 Thread Simon Green
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