Griggs, Donald a écrit : > 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. > What do you use to compile, I just added rtree.c to my vc6 project and it compiled right away. I've not tested it yet, however :-{
Best wishes Noël > 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 > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users