we are working on automotive traking solutions and insert our location records into the mysql database v 4.1.20. If we want search for a particular record, its taking too long time and mysql is identifying the queries as slow queries. I have attached the queries.
You've posted this multiple times, that's just going to annoy everyone. Break the query down and find out which part is slow. Each union part should work by itself, so take each one and tune that. Then worry about the whole lot. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]