Client hangs when selecting 100,100 records
Client hangs when selecting 100,100 records
(OP)
Hello good people
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
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