#sqlpagination — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlpagination, aggregated by home.social.
-
Why does this SQL OFFSET get slower with every page?
Why does this SQL OFFSET get slower with every page. The SQL code uses OFFSET for pagination. In MySQL OFFSET forces a full scan and skip. In SQL page 10000 can take minutes.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqloffset #sqlpagination #sqlkeyset #sqlscaling
-
Why does this SQL OFFSET get slower with every page?
Why does this SQL OFFSET get slower with every page. The SQL code uses OFFSET for pagination. In MySQL OFFSET forces a full scan and skip. In SQL page 10000 can take minutes.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqloffset #sqlpagination #sqlkeyset #sqlscaling
-
Why does this SQL OFFSET get slower with every page?
Why does this SQL OFFSET get slower with every page. The SQL code uses OFFSET for pagination. In MySQL OFFSET forces a full scan and skip. In SQL page 10000 can take minutes.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqloffset #sqlpagination #sqlkeyset #sqlscaling