Memcache + Dynamic Query Filters

Dustin Sallings 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  
key/value pairs.

-- 
Dustin Sallings


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.danga.com/pipermail/memcached/attachments/20070930/38d53b5b/attachment.html


More information about the memcached mailing list