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]
