8/21/2023 0 Comments Mysql uuid primary key defaultSimply adding an index would help immensely.Īddin an index would speed up the operation then there would be up to 10-100 disk reads to get a resultset. What you have: Well you don't even have an index on object_id, so it needs to scan the table. This allows multiple clients insert rows without worry about dups.Īll 3 cases will improve performance because the 10-100 rows can be fetched more efficiently. (BIGINT is 8 bites, a lot smaller than what you seem to have now.) Note that AUTO_INCREMENT lets you insert rows without specifying id a number will be generated for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |