SQLite Forum

another performance question related to `geopoly`
Login
I can't figure out why my `geopoly` code is slow and how to make it fast. It also seems that either I am asking the question in a wrong way or there is not much interest or insight in the workings of `geopoly` (RTree) on this forum since three of my `geopoly` related questions have gone without a reply. Consequently, I have decided to stop using `geopoly` esp since a standard `BETWEEN` clause seems to work very well (as detailed in my last example above).

In case someone else stumbles upon this with a similar problem – I am using `turf.js` library to create a bbox around my point with the provided radius (actually I first create a buffer and then create a bbox for the buffer). That gives me the min and max lat and lng which I use in my `latitude BETWEEN min_lat AND max_lat` and `longitude BETWEEN min_lng AND max_lng` SQL. Hope this is helpful.