Hi Andrew, Maybe this goes without saying, but I guess you've already worked on the "usual suspects" such as:
-- An index for Lat and another for Lon. -- Larger cache -- EXPLAIN QUERY PLAN prefix to ensure that index used -- One-time VACUUM has any effect? -- ANALYZE -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Brampton Sent: Friday, June 13, 2008 11:52 AM To: sqlite-users@sqlite.org Subject: [sqlite] rtree extension - Windows Binary? Hi, I've recently created a database with latitude/longitude points in it, and now I need to search for points without a given rectangle. With 60,000 points I'm able to retrieve a rectangle of 50 points in ~1 second. This is way too slow, so I wanted to try out the rtree extension. However at the moment I'm unable to compile it, so I was wondering if anyone had a DLL for windows which I could use. I am using PHP 5.x to access my SQLite database, so the extension must be compatible with the sqlite included with that. Would anyone be able to give me such a DLL? Also is there a good write up on how to use this extension? I've been following the mailing list, but another source would be helpful. thanks Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
