In MySQL, does altering a table's AUTO_INCREMENT value to start at a really high value affect read/write performance?
-
This is compared to a scenario of a table which has the same number of rows (O(10MM)) but has AUTO_INCREMENT that started at 0 (vs. something O(100MM)).
-
Answer:
I really doubt it: integers are fixed-sized, so either way the computer has to deal with the same number of bits during integer comparisons or disk IO. The only issue I can see is if the higher start value meant you had to use BIGINT instead of INT, but that's not the case here. I'm assuming that you're inserting data into initially empty tables, since otherwise you might see performance changes due to the alter command rebuilding your index/table. Disclaimer: I don't know much about how computers or MySQL work on a low level and I probably shouldn't be answering this question.
Ted Suzman at Quora Visit the source
Related Q & A:
- How does MySQL reindex a table?Best solution by Stack Overflow
- How to create a table in PHP with MySQL?Best solution by Stack Overflow
- How can information systems affect a company’s bottom line (such as financial performance?Best solution by Yahoo! Answers
- How can an I.S. department affect a company's bottom line,like their performance?Best solution by Yahoo! Answers
- How do you write a really good CV?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.