DEV Community

loading...

Discussion on: 1 SQL Query You Should Stop Using

Collapse
robloche profile image
Robloche

Are you talking about MySQL?
Because I have an SQL Server stored procedure that uses OFFSET and FETCH NEXT to browse through a 500K-row table and the execution time is stable throughout the table.

Collapse
abdisalan_js profile image
Abdisalan Author

I'm using PostgreSQL and no stored procedures. That's awesome that MySQL can do that!

Collapse
robloche profile image
Robloche

Sorry for the confusion. I'm using SQL Server, and yes, it seems correctly optimized for this situation.