title: How can I improve pagination performance in multiple queryset django?
body: <p>I have 2 queryset :</p>
  
  <pre><code>queryset_primary = PrimaryUserSerializer(FileUpload.objects.all().order_by('name'), many=True, context=context).data
  queryset_secondary = MemberSerializer(Members.objects.all().order_by('member_name'), many=True, context=context).data
  </code></pre>
  
  <p>Both having different keys ..so that I iterated both querysets :</p>
  
  <pre><code>    response = []
      for primary in queryset_primary:
          # name_pri=primary['primary_user_id']
          new_data={ 
              'user_id' : primary['primary_user_id'],
              'name': primary['name'],
          }
          response.append(new_data)
  
      for secondary in queryset_secondary:
          new_data={
              'user_id' : secondary['secondary_user_id'],
              'name': secondary['member_name'],
          }
  </code></pre>
  
  <p>Again I used a common serializer having similar keys in it, for pagination :</p>
  
  <pre><code>    responses = self.paginate_queryset(response)
      if responses is not None:
          serializer = CommonUserSerializer(responses,many=True)
          data = {
              'code': 200,
              'status': "OK",
          }
          page_nated_data = self.get_paginated_response(serializer.data).data
          data.update(page_nated_data)
          data['response'] = data.pop('results')
          return Response(data)
  </code></pre>
  
  <p>It totally taking 8 seconds of loading time.</p>
  
  <p>How can I reduce the API loading time ?</p>