Hi All,
I encounter problem with the below SQL (it does not turn data from my database):
SELECT l.link_id, l.cat, l.bi_direction, l.frm_coord_id, l.to_coord_id, r.name,
l.start_jtn_elev, l.end_jtn_elev, r.id, r.code, r.prefix FROM Links l,
Links_Index x, Roads r WHERE l.link_id = x.link_id AND
Hi all,
Currently i'm using SQLite 3.6.22 for my system. I know the latest SQLite is
version 3.7.7; im just wondering if i should update SQLite in my system. Is
there any significant change in the this latest SQLite?
Please advise. Thanks.
Linh
___
org> wrote:
>
> On 15 Jun 2011, at 3:56am, Hoang Linh Duong wrote:
>
> > I have tried R-Tree, the execution time is even longer.
> >
> > For a trigger to calculate the distance, is it too much a burden if the
> > query is executed very frequently (the table Location
I have tried R-Tree, the execution time is even longer.
For a trigger to calculate the distance, is it too much a burden if the
query is executed very frequently (the table Location is of more than 600k
records). I suspect that it may take even longer time if we need to do
update & query.
After
ex on category and distance, like
>
> create index MyIndex on Location (category, distance)
>
> Because many records fulfill the category=17 condition, and if database
> size is an issue, an index only on distance might help also.
>
> Martin
>
>
> Am 14.06.2011 13:01, schrieb
Hi all,
I have one SQL as below:
SELECT name, type, category, x, y, ((x-645529)*(x-645529) +
(y-1494293)*(y-1494293)) AS distance,
FROM Location
WHERE category=17
ORDER BY distance
LIMIT 100
I run this SQL to retrieve data from my SQLITE database and it takes more
than 1 minutes. Noted that my
6 matches
Mail list logo