Hello good people<br>
<br>
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.<br>
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.<br>
I'd also like to note that I'm using a source distribution which I have recompiled to use the gnu pthreds.<br>
<br>
Here is my select clause. I wanted to post the table descriptions, but they don't appear so good upon paste.<br>
<br>
SELECT Customers.COMPANY_ID, Customers.CUSTOMER_ID, Customers.ADDRESS, Customers.NAME, Customers.SITE_ID, Sites.NAME, Buildings.ADDRESS<br>
FROM CUSTOMERS Customers, SITES Sites, BUILDINGS Buildings<br>
WHERE (Customers.COMPANY_ID = Sites.COMPANY_ID) <br>
AND (Sites.COMPANY_ID = Buildings.COMPANY_ID) <br>
AND (Sites.SITE_ID = Buildings.SITE_ID) <br>
AND ( (Customers.REPLACED <> '1') <br>
AND (Customers.CURRENT_STATUS = '3') ) <br>
<br>
I would love to hear any suggestions.<br>
<br>
Thanks in advance<br>
Isaac Aaron
<br>
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.<br>
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.<br>
I'd also like to note that I'm using a source distribution which I have recompiled to use the gnu pthreds.<br>
<br>
Here is my select clause. I wanted to post the table descriptions, but they don't appear so good upon paste.<br>
<br>
SELECT Customers.COMPANY_ID, Customers.CUSTOMER_ID, Customers.ADDRESS, Customers.NAME, Customers.SITE_ID, Sites.NAME, Buildings.ADDRESS<br>
FROM CUSTOMERS Customers, SITES Sites, BUILDINGS Buildings<br>
WHERE (Customers.COMPANY_ID = Sites.COMPANY_ID) <br>
AND (Sites.COMPANY_ID = Buildings.COMPANY_ID) <br>
AND (Sites.SITE_ID = Buildings.SITE_ID) <br>
AND ( (Customers.REPLACED <> '1') <br>
AND (Customers.CURRENT_STATUS = '3') ) <br>
<br>
I would love to hear any suggestions.<br>
<br>
Thanks in advance<br>
Isaac Aaron