mysql performance

MySQL & MariaDB Other MySQL® Questions
1

Hi!

I searched the whole site for this topic and it says that there’s no posting about this subject, but would like to know if there’s a way on MySQL that you can query large chunks of data faster and improve your performance. In Oracle you have several SQL alternatives that could help you with that such as ROWS FETCH NEXT, BULK… Comments are welcome!

M

2

mysql does a pretty good job with a simple cursor when you are traversing on a primary key, you can update records in batches of 100 or 1000 ( where id between 1 and 1000). I do that all the time and it’s really fast. I don’t think mysql has anything that BULK COLLECT, as long as you query on PK, it should be fast.