126 reputation
4
bio website encodez.com
location Doha, Qatar
age
visits member for 2 years, 3 months
seen Mar 25 at 5:41

I am a technology enthusiast currently employed in Doha, Qatar a region in Middle-East. Now being in a position of Senior Developer at a reputed firm.


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?