Not the answer you need?
Register and ask your own question!

mysql performance

madonnamadonna EntrantInactive User Role Beginner
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

Comments

  • rreddyrreddy Contributor Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.