Hello! I would like to use memcached as a fast cache for a hospital order database.
Each order has a location (5 possible values), procedure (about 100 possible values), and patient status (3 different values). So, my thinking was for each order, create a key as follows: (location code)_(procedure code)_(status code) and the value would be a list of all orders matching a given code. So, doing a query on a given location, procedure and status will just entail reading the value from the key. My question is: what is the best way of modifying the value, as an in- memory list. Can this be done on the memcached server, or do I need the client to pull the value out, modify it, and put it back in? Thanks!
