PHWinfo - Afficher un message - Re: adding LIMIT 1 to improve performance?

20/09/2007, 09h31

> > Before you do, what makes you think that adding LIMIT 1 to a
> > statement that searches the rows to modify by PRIMARY KEY!!
> > value would become any faster?
>
> as I said, I noticed phpmyadmin does that, so I got this doubt and
> asked here (since it's not mentioned in the docs, AFAIK)

It's probably just a standard thing PHPMyAdmin does for all table
updates, even the ones without a PK, to ensure only 1 row gets
updated.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

20/09/2007, 09h31	#6
Martijn Tonies Messages: n/a Hébergeur:	Re: adding LIMIT 1 to improve performance? > > Before you do, what makes you think that adding LIMIT 1 to a > > statement that searches the rows to modify by PRIMARY KEY!! > > value would become any faster? > > as I said, I noticed phpmyadmin does that, so I got this doubt and > asked here (since it's not mentioned in the docs, AFAIK) It's probably just a standard thing PHPMyAdmin does for all table updates, even the ones without a PK, to ensure only 1 row gets updated. -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com