Please send me the actual physical query that was locking things up.
This sounds like a simple join, include table/key structures in your
response.
More than likely you aren't joining somewhere "nicely", and if you don't,
you end up with really really large result sets.
----- Original Message -----
From: "Paul Wilkinson" <[EMAIL PROTECTED]>
To: "Help MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 1:08 PM
Subject: URGENT !! Hanging query
> PLEASE if anyone can help!! We are past deadline
>
> Object: Retrieve rows from table D.
>
> GIVEN:
> 1. MySQL ver 3.23.33 (but must run on 3.22.25!)
> 2. Table D is connected to tables E,F,K through tables dE,dF,dK.
> 3. Table D is connected to table L through tables dK then Lk.
>
> D - dE - E
> D - dF - F
> D - dK - K
> D - dK - Lk - L
>
> 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K,
L
> 5. Each table E,F,K,L has less than 1000 rows.
> 6. Each string field is indexed
> 7. Each joiner field is indexed
>
> NEED:
> 1. WHERE clause which checks exact matches for E,F and L tables and
> substring match for words in K.
> 2. Multiple words to limit results to intersection of returns
> 3. Ordered by number of rows in dE,dF, then dK (both L and K)
> 4. List only unique rows in D
>
> I have tryed several things to create various queries in PHP, some which
are
> as large as 2500 characters!
>
> The only thing that I can think of now is Does each AND section of the
WHERE
> clause have to have ALL unique table aliases? (down to the last common
one?)
>
> Paul
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
