Re: [sqlite] Effective way to use RTree to find the neighborhood ???

Hi, > LOCAL: RTREE 8x faster then my OLD implementation > NET: OLD is 2x faster then RTREE > Can I use some special caching concepts? How can I > improve the run-time in the NETWORK environment? You could use/write also a small Appserver-Layer - and perform the query locally then at the serv

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

On 23/01/2009 12:58 AM, Igor Tandetnik wrote: > "Sergej Schwarz" wrote in > message news:20090122133954.74...@gmx.net >> unfortunately, this does not work, the RTree documentation by SQLite >> leads to misunderstanding of the concept... The query would results >> in an empty set. >> >> //your quer

Re: [sqlite] Effective way to use RTree to find the neighborhood ?? ?

Sergej Schwarz wrote: > Amazing! Thanks Guys! This query working best! > > The runtime difference between LOCAL execution and execution in LAN > environment is still absolutely a show stopper! The old algorithm (get all > polygon data from Polygon table) and search for the neighbors in C++ is >

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

"Igor Tandetnik" > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Effective way to use RTree to find the neighborhood ??? > "Sergej Schwarz" wrote in > message news:20090122133954.74...@gmx.net > > unfortunately, this does not work, the RTree documentatio

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

"Sergej Schwarz" wrote in message news:20090122133954.74...@gmx.net > unfortunately, this does not work, the RTree documentation by SQLite > leads to misunderstanding of the concept... The query would results > in an empty set. > > //your query > select * from demo where x1>=3 and x2<=19 and y1>=2

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

t; Von: Dan > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] Effective way to use RTree to find the neighborhood ??? > > On Jan 22, 2009, at 6:48 PM, Sergej Schwarz wrote: > > > Dear all, > > > > I'm using RTree to have FAST possibility to

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

On Jan 22, 2009, at 6:48 PM, Sergej Schwarz wrote: > Dear all, > > I'm using RTree to have FAST possibility to extract all the > polygons, which intersect a specified window, overlap this specified > window or are completely in this window. Please see the picture at > http://home.arcor.de/sc

[sqlite] Effective way to use RTree to find the neighborhood ???

Dear all, I'm using RTree to have FAST possibility to extract all the polygons, which intersect a specified window, overlap this specified window or are completely in this window. Please see the picture at http://home.arcor.de/schwar_s/images/polygons.jpg. The idea is to find all the polygons