[ckan-dev] key value store, caching and redis

[William Waites]

* [2011-01-31 09:41:09 +0000] David Raznick <kindly at gmail.com> écrit:

] So I cant imagine a case where a simple   "select * from package where
] package_id in (package1_id, package2_id, package3_id)"  will not suffice to
] emulate a join with no performance issues.

Except where (package1_id, packate2_id, ...) is long. There will
be a point where it is more efficient to do the join in the other
direction, e.g. "select 10 most recently modified packages and
join with other data from redis or whatever".

-w
-- 
William Waites                <mailto:ww at styx.org>
http://eris.okfn.org/ww/         <sip:ww at styx.org>
F4B3 39BF E775 CF42 0BAB  3DF0 BE40 A6DF B06F FD45