Hello list
I have a problem regarding MySQL, and thought maybe one of you would have
an idea. I'm also looking for a good discussion forum specific to MySQL if
anyone knows. I tried Tek-Tips (BTW- great site design. I wish the ILUG
mailing list would run on a site like this), but the MySQL forum they have
there is complete abandoned.
I'm running MySQL 3.2.26a and everying works nicely, except for the fact
that when I issue a query which involves 3 tables, and the result should be
about 100,000 records, my client hangs. I'm using BDE 5.1/Windows NT on the
client side, but this query hangs even the generic MySQL client which is
shipped with the distribution.
All of the fields included in this clause are indexed and other than that,
server performance is of great satisfactory. Issuing a SELECT query just on
the CUSTOMERS table, which contains about 100,000 records works fine.
I'd also like to note that I'm using a source distribution which I have
recompiled to use the gnu pthreds.
Here is my select clause. I wanted to post the table descriptions, but they
don't appear so good upon paste.
SELECT Customers.COMPANY_ID, Customers.CUSTOMER_ID, Customers.ADDRESS,
Customers.NAME, Customers.SITE_ID, Sites.NAME, Buildings.ADDRESS
FROM CUSTOMERS Customers, SITES Sites, BUILDINGS Buildings
WHERE (Customers.COMPANY_ID = Sites.COMPANY_ID)
AND (Sites.COMPANY_ID = Buildings.COMPANY_ID)
AND (Sites.SITE_ID = Buildings.SITE_ID)
AND ( (Customers.REPLACED <> '1')
AND (Customers.CURRENT_STATUS = '3') )
I would love to hear any suggestions.
Thanks in advance
Isaac Aaron
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
