On Tuesday 22 January 2002 13:18, Sommai Fongnamthip wrote:

> Hi,
>       I have problem with these mysql's query:
>
>       select * from holder, management where holder.id=management.id or
> (holder.name=management.name and holder.surname=management.surname) order
> by holder.no
>
>       It take a long time (more than 1 minute) with thousand record.  I have
> index within 2 table (name+surname, id).  It did not have problem if I
> check only id or name+surname.

This is a mysql question. Perhaps you should ask on the mysql list.


-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk

/*
One expresses well the love he does not feel.
                -- J.A. Karr
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to