hi,
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.
How to optimize the
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
: Tuesday, August 01, 2006 5:28 PM
Subject: tune a geometric query
hi,
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
On Tue, 2006-08-01 at 17:39 +0530, ViSolve DB Team wrote:
Hello Prashant,
If you do need the duplicate rows in the final result, use UNION ALL with
your query. Otherwise you can opt for UNION as UNION is faster than UNION
ALL.
I have never heard of any evidence of this; in fact, it makes