GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

mysql performance

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql performance

    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.

    Comment

    Working...
    X