Caching location based data?
josh at agliodbs.com
Thu Aug 2 15:06:46 UTC 2007
> Our site is custom written PHP and MySQL. We use memcache extensively to
> cache many of our SQL queries. I’m wondering if anyone can think of a
> more elegant solution then the one we have devised.
Out of curiosity, why aren't you using PostGIS? It has special indexing
types for the sort of query you mention. While not as fast as memcached, if
you can keep those indexes in memory they are < 50ms to return a lot of
At some point I'll also post a proof-of-concept for the db-based invalidation
technique I'm using for one project which can get around the regex
invalidation not being implemented yet.
PostgreSQL @ Sun
More information about the memcached