On Sun, Nov 13, 2011 at 6:55 PM, Maxim Potekhin <potek...@bnl.gov> wrote: > Thanks to all for valuable insight! > > Two comments: > a) this is not actually time series data, but yes, each item has > a timestamp and thus chronological attribution. > > b) so, what do you practically recommend? I need to delete > half a million to a million entries daily, then insert fresh data. > What's the right operation procedure?
I'd have to know more about what your access pattern is like to give you a fully informed answer. > For some reason I can still select on the index in the CLI, it's > the Pycassa module that gives me trouble, but I need it as this > is my platform and we are a Python shop. This seems odd, since the rpc_timeout is the same for all clients. Maybe pycassa is asking for more data than the cli? -Brandon