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: Fri Jul 10 01:49:45 EDT 2009

Total time taken to generate the page: 0.11714 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.