MySQL Performance: MySQL => autoincrement in mysql vs oracle

Members

Help

Home

Home » Performance » MySQL » autoincrement in mysql vs oracle

Show: Today's Messages :: Show Polls :: Message Navigator

autoincrement in mysql vs oracle [message #845]

Sat, 03 March 2007 10:50

howachen
Messages: 7
Registered: February 2007

Junior Member

oralce dose not have autoincrement field, what are the reason related to performance?

if there are some performance drawback, why mysql does not follow oralce approach?

thanks.

Report message to a moderator

Re: autoincrement in mysql vs oracle [message #848 is a reply to message #845 ]

Sat, 03 March 2007 18:20

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Oracle does not have auto increment because it has sequences I guess.

MySQL does not have sequences because for most MySQL users auto_increment is enough.

I'd think so at least.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Previous Topic:	mysql connect error
Next Topic:	MySQL Replication

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 20 20:07:52 EST 2008

Total time taken to generate the page: 0.02814 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.