Re:Why MongoDB is a bad choice for storing our scraped data
by dkhenry on Tuesday May 14, 2013 @04:45PM
(#5707979)
Right for that example ,not knowing the specifics, I would index on timestamp and then I could sort by timestamp which once indexed should be a relativly fast operation. I could even go one step better and make the _id a construct of
{ <timestamp>,<loglevel>,<fuzz> }
Then Inserting would be done in order and I would get a magic index for free (depending on if I often query by loglevel I might leave it out) This gives locality of timestamps and helps keep "Hot" sections in memory.
[ Parent
| on HN ]
There are no comments on this comment yet.