Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
4
Impact
~153 people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Mar
2
comment Slow query while selecting a higher offset from millions of rows
actually, it is an security audit. User should be able to check any location of the table. viewing page 1 by 1 is not practical for such a huge data. So it should be possible to jump to any location by page numbers.
Mar
2
comment Slow query while selecting a higher offset from millions of rows
sounds good, But I use limit because of the pagination.
Mar
2
asked Slow query while selecting a higher offset from millions of rows
Sep
24
awarded  Autobiographer
Dec
6
awarded  Teacher
Dec
6
awarded  Custodian
Dec
6
reviewed Approve Joining 4 tables and 2 counts
Dec
6
answered Joining 4 tables and 2 counts
Dec
6
awarded  Supporter
Dec
6
comment Joining 4 tables and 2 counts
one my suggestion if you can, try to reduce the joins and run the code minimum col as possible, once it is ok, add the extra joins one by one and test it. It might help you which place you slip.
Dec
6
comment Joining 4 tables and 2 counts
Are you getting the correct result after 1 minute of time when the execution finished?