On Tuesday 22 January 2002 13:18, Sommai Fongnamthip wrote:
> 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]