I may help you to execute your query in less than 20mn.
Question : count(*) from EMP = ?
Mathias
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: dimanche 24 avril 2005 17:39
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: mysql_performance
Moemen,
You a
Moemen,
You assign a string _position_ result from LOCATE to a SUBSTRNG _length_
argument. Is that what you mean?
Do you have indexes on persons.item_id, emp (item_id, item_type, f2, f6,
f7)? Once there are such indexes, try ordering the WHERE ... ANDs to
correspond to those keys so the optimis