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.


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