CODEWITHSUNDEEP
phpmysql
mathew
mathew

Reputation: 21

do I need to use insert delayed in this scenario?

I do have a Mysql database table which is always reading and inserting at a time. so do I need to use INSERT DELAYED option to optimize the process?? reading is primary concern and insert is secondary..

Upvotes: 2

Views: 281

Answers (1)

tskuzzy
tskuzzy

Reputation: 36476

Yes if reading is the primary concern then you should use INSERT DELAYED.

The DELAYED option for the INSERT statement is a MySQL extension to standard SQL that is very useful if you have clients that cannot or need not wait for the INSERT to complete.

This will also make INSERTs faster if there are a lot of separate INSERTs being made. This is because they are bundled together and written in one block.

MySQL Reference Manual

Upvotes: 2

Related Questions