That's one reason why switching auto-increments to bigint does help (a lot): htt... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		rs on June 6, 2012 \| parent \| context \| favorite \| on: Loading half a billion rows into MySQL That's one reason why switching auto-increments to bigint does help (a lot): http://dev.mysql.com/doc/refman/5.5/en/integer-types.html

Cyndre on June 9, 2012 [–]

That is interesting to know, I have been setting my index's to bigint for a long time.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact