I don't see how LIMIT would make a difference. LAST_INSERT_ID() only returns one record.
But it's worth trying in a big loop to get timing numbers. >>I have a rather simple straightforward question that I was not able to find >>in any of the documentation. >>I am in the process of writing an application, and I was wonder whether >>there is any benefit (or penalty) in LIMIT(ing) a LAST_INSERT_ID() query? >> >>i.e. >>SELECT LAST_INSERT_ID() FROM foo >>vs. >>SELECT LAST_INSERT_ID() FROM foo LIMIT 1 >> >>Thanks in advance, >>Eric Absgarten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
