How to speed up database performance

Question

I want to Fetch 1000+ row and perform crud operation but it lagging . any tips?

Answer 1

If upgrading hardware is not an option, all you can do is to make sure that the structure of the database is not redundant. When you are fetching records, attempt to omit attributes/columns which are not needed.

Answer 2

What if I want to Fetch all column