query problem
| From: | Sommai Fongnamthip | Date: | Tue, 22 Jan 2002 05:18:07 +0000 |
| Subject: | query problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16042@lists.php.net to get a copy of this message | ||
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.
SF