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
