Memcache + Dynamic Query Filters
dustin at spy.net
Sun Sep 30 07:37:28 UTC 2007
On Sep 29, 2007, at 23:40, Rakesh Rajan wrote:
> One of my sample query ( sql ) looks like
> select * from table where type = 1 and ( occurred_date between
> 'some date' and 'some date');
> Has someone out here dealt with date range based querying using
> memcached before or have any ideas around how to use ( if at all )
> memcached for such dynamic queries ?
I think the closest you could reasonably get is to have that query
only return identifiers and pull the heavier stuff from memcached.
Doing that will reduce your joins and the general IO requirements of
the DB (assuming the objects are populated, of course).
There's no search language on top of memcached, though. It's just
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the memcached