> On 16 Set, 20:10, Brian Wakem <n...@email.com> wrote:
> > Why don't you write a script to benchmark it? Do it with and without
LIMIT
> > 1 a few hundred thousand times each, repeat the test half-a-dozen times
and
> > post your results.
> >
> > Make sure you turn off query cache first if the queries are selects.
>
> great idea!! I'll let you know (but not soon, I'll do that in later
> stages in this case

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?


--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com