Access patterns

Access Pattern

Updates:

totals 
  { 'b' }

tracks 
  { 't', 'b', 'u' } # This is theoretically irrelevant 
                    # because track links 1-to-1 to user
  { 't', 'b' }

users  
  { 'u', 'b' }
  { 'u', 'b' }

listeners/track(/slim)
  { 't', 'b', 'v' }

listeners/user(/slim)
  { 'u', 'b', 'v' }
  
apps/track(/slim)
  { 't', 'b', 'v' }

apps/user(/slim)
  { 'u', 'b', 'v' }
  
countries/track/slim
  { 't', 'b', 'v' }

countries/user/slim
  { 'u', 'b', 'v' }

referrers/track(/slim)
  { 't', 'b', 'r' }

referrers/user(/slim)
  { 't', 'b', 'r' }
  
  
Finds:

tracks 
  { 't', 'b' }
  { 'u', 'b' }.sort({'p', 'd', 'c', 'f' (-1)})

users
  { 'u', 'b' }

listeners/track [ slim not hit ]
  { 't', 'b' }.sort({'p', 'd', 'c', 'f' (-1)})
  { 't', 'b', 'v' }
  
listeners/user [ slim not hit ]
  { 'u', 'b' }.sort({'p', 'd', 'c', 'f' (-1)})
  { 'u', 'b', 'v' }
  
apps/track [ slim not hit ]
  { 't', 'b' }.sort({'p', 'd', 'c', 'f' (-1)})
  { 't', 'b', 'v' }

apps/user [ slim not hit ]
  { 'u', 'b' }.sort({'p', 'd', 'c', 'f' (-1)})
  { 'u', 'b', 'v' }
  
countries/track/slim
  { 't', 'b', 'v' }

countries/user/slim
  { 'u', 'b', 'v' }
  { 'u', 'b' }

referrers/track [ slim not hit ]
  { 'r', 'b' }.sort({'p' (-1)})
  { 't', 'b', 'r' }

referrers/user [ slim not hit ]
  { 'u', 'b' }.sort({'p' (-1)})
  { 'u', 'b', 'r' }