[sqlite] SQLITE query not working

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

[sqlite] Should i upgrade SQLITE for my system?

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 ___

Re: [sqlite] SQLITE run slow

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

Re: [sqlite] SQLITE run slow

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

Re: [sqlite] SQLITE run slow

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

[sqlite] SQLITE run slow

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