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 ma
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 as
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 t
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 attac
