×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Client hangs when selecting 100,100 records

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close